{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import tushare as ts\n",
    "\n",
    "df = ts.get_stock_basics()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>industry</th>\n",
       "      <th>area</th>\n",
       "      <th>pe</th>\n",
       "      <th>outstanding</th>\n",
       "      <th>totals</th>\n",
       "      <th>totalAssets</th>\n",
       "      <th>liquidAssets</th>\n",
       "      <th>fixedAssets</th>\n",
       "      <th>reserved</th>\n",
       "      <th>...</th>\n",
       "      <th>bvps</th>\n",
       "      <th>pb</th>\n",
       "      <th>timeToMarket</th>\n",
       "      <th>undp</th>\n",
       "      <th>perundp</th>\n",
       "      <th>rev</th>\n",
       "      <th>profit</th>\n",
       "      <th>gpr</th>\n",
       "      <th>npr</th>\n",
       "      <th>holders</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>600249</th>\n",
       "      <td>两面针</td>\n",
       "      <td>日用化工</td>\n",
       "      <td>广西</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.50</td>\n",
       "      <td>5.50</td>\n",
       "      <td>323929.22</td>\n",
       "      <td>99010.27</td>\n",
       "      <td>114079.50</td>\n",
       "      <td>85739.86</td>\n",
       "      <td>...</td>\n",
       "      <td>3.52</td>\n",
       "      <td>1.83</td>\n",
       "      <td>20040130</td>\n",
       "      <td>11563.82</td>\n",
       "      <td>0.21</td>\n",
       "      <td>-5.29</td>\n",
       "      <td>23.70</td>\n",
       "      <td>20.24</td>\n",
       "      <td>-6.53</td>\n",
       "      <td>62924.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000795</th>\n",
       "      <td>英洛华</td>\n",
       "      <td>矿物制品</td>\n",
       "      <td>山西</td>\n",
       "      <td>71.17</td>\n",
       "      <td>6.86</td>\n",
       "      <td>11.34</td>\n",
       "      <td>262512.06</td>\n",
       "      <td>179590.45</td>\n",
       "      <td>60635.76</td>\n",
       "      <td>107166.20</td>\n",
       "      <td>...</td>\n",
       "      <td>1.83</td>\n",
       "      <td>3.53</td>\n",
       "      <td>19970808</td>\n",
       "      <td>-17884.21</td>\n",
       "      <td>-0.16</td>\n",
       "      <td>12.48</td>\n",
       "      <td>197.13</td>\n",
       "      <td>23.33</td>\n",
       "      <td>5.53</td>\n",
       "      <td>96700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000151</th>\n",
       "      <td>中成股份</td>\n",
       "      <td>商贸代理</td>\n",
       "      <td>北京</td>\n",
       "      <td>45.23</td>\n",
       "      <td>2.67</td>\n",
       "      <td>2.96</td>\n",
       "      <td>230761.38</td>\n",
       "      <td>188807.98</td>\n",
       "      <td>6801.99</td>\n",
       "      <td>44202.68</td>\n",
       "      <td>...</td>\n",
       "      <td>3.29</td>\n",
       "      <td>4.07</td>\n",
       "      <td>20000906</td>\n",
       "      <td>9714.25</td>\n",
       "      <td>0.33</td>\n",
       "      <td>75.97</td>\n",
       "      <td>-13.01</td>\n",
       "      <td>13.48</td>\n",
       "      <td>4.15</td>\n",
       "      <td>37069.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002208</th>\n",
       "      <td>合肥城建</td>\n",
       "      <td>区域地产</td>\n",
       "      <td>安徽</td>\n",
       "      <td>148.56</td>\n",
       "      <td>3.19</td>\n",
       "      <td>3.20</td>\n",
       "      <td>1160278.00</td>\n",
       "      <td>1148314.00</td>\n",
       "      <td>6756.07</td>\n",
       "      <td>29001.14</td>\n",
       "      <td>...</td>\n",
       "      <td>5.10</td>\n",
       "      <td>2.67</td>\n",
       "      <td>20080128</td>\n",
       "      <td>74377.09</td>\n",
       "      <td>2.32</td>\n",
       "      <td>-18.72</td>\n",
       "      <td>-66.96</td>\n",
       "      <td>26.76</td>\n",
       "      <td>1.64</td>\n",
       "      <td>34015.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300655</th>\n",
       "      <td>晶瑞股份</td>\n",
       "      <td>化工原料</td>\n",
       "      <td>江苏</td>\n",
       "      <td>87.70</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.88</td>\n",
       "      <td>71158.15</td>\n",
       "      <td>49096.92</td>\n",
       "      <td>16603.92</td>\n",
       "      <td>23198.64</td>\n",
       "      <td>...</td>\n",
       "      <td>4.71</td>\n",
       "      <td>6.49</td>\n",
       "      <td>20170523</td>\n",
       "      <td>8065.47</td>\n",
       "      <td>0.91</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>27.95</td>\n",
       "      <td>5.99</td>\n",
       "      <td>10552.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300523</th>\n",
       "      <td>辰安科技</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>北京</td>\n",
       "      <td>3536.31</td>\n",
       "      <td>1.01</td>\n",
       "      <td>1.44</td>\n",
       "      <td>114180.32</td>\n",
       "      <td>96789.85</td>\n",
       "      <td>12613.92</td>\n",
       "      <td>40365.45</td>\n",
       "      <td>...</td>\n",
       "      <td>6.04</td>\n",
       "      <td>8.73</td>\n",
       "      <td>20160726</td>\n",
       "      <td>22047.11</td>\n",
       "      <td>1.53</td>\n",
       "      <td>14.30</td>\n",
       "      <td>-68.01</td>\n",
       "      <td>54.85</td>\n",
       "      <td>0.64</td>\n",
       "      <td>11525.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603506</th>\n",
       "      <td>南都物业</td>\n",
       "      <td>房产服务</td>\n",
       "      <td>浙江</td>\n",
       "      <td>51.14</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.79</td>\n",
       "      <td>72642.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>4.35</td>\n",
       "      <td>9.98</td>\n",
       "      <td>20180201</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8.71</td>\n",
       "      <td>18531.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300732</th>\n",
       "      <td>设研院</td>\n",
       "      <td>建筑施工</td>\n",
       "      <td>河南</td>\n",
       "      <td>39.73</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.72</td>\n",
       "      <td>147598.91</td>\n",
       "      <td>108083.01</td>\n",
       "      <td>20620.30</td>\n",
       "      <td>33782.26</td>\n",
       "      <td>...</td>\n",
       "      <td>21.23</td>\n",
       "      <td>4.19</td>\n",
       "      <td>20171212</td>\n",
       "      <td>32869.48</td>\n",
       "      <td>4.57</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47.88</td>\n",
       "      <td>22.71</td>\n",
       "      <td>16942.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600405</th>\n",
       "      <td>动力源</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>北京</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.53</td>\n",
       "      <td>5.62</td>\n",
       "      <td>297222.53</td>\n",
       "      <td>174515.36</td>\n",
       "      <td>89155.57</td>\n",
       "      <td>55612.67</td>\n",
       "      <td>...</td>\n",
       "      <td>2.35</td>\n",
       "      <td>2.95</td>\n",
       "      <td>20040401</td>\n",
       "      <td>21281.20</td>\n",
       "      <td>0.38</td>\n",
       "      <td>-13.32</td>\n",
       "      <td>-208.35</td>\n",
       "      <td>32.16</td>\n",
       "      <td>-3.28</td>\n",
       "      <td>120031.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300647</th>\n",
       "      <td>超频三</td>\n",
       "      <td>元器件</td>\n",
       "      <td>深圳</td>\n",
       "      <td>78.98</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1.23</td>\n",
       "      <td>83115.93</td>\n",
       "      <td>42642.17</td>\n",
       "      <td>25424.42</td>\n",
       "      <td>25124.00</td>\n",
       "      <td>...</td>\n",
       "      <td>4.30</td>\n",
       "      <td>5.58</td>\n",
       "      <td>20170503</td>\n",
       "      <td>13382.12</td>\n",
       "      <td>1.09</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>35.52</td>\n",
       "      <td>11.45</td>\n",
       "      <td>16598.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603712</th>\n",
       "      <td>七一二</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>天津</td>\n",
       "      <td>155.04</td>\n",
       "      <td>1.00</td>\n",
       "      <td>7.72</td>\n",
       "      <td>348015.50</td>\n",
       "      <td>277392.63</td>\n",
       "      <td>57633.35</td>\n",
       "      <td>63780.73</td>\n",
       "      <td>...</td>\n",
       "      <td>2.29</td>\n",
       "      <td>9.00</td>\n",
       "      <td>20180226</td>\n",
       "      <td>20558.85</td>\n",
       "      <td>0.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>49.57</td>\n",
       "      <td>8.39</td>\n",
       "      <td>88473.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300731</th>\n",
       "      <td>科创新源</td>\n",
       "      <td>橡胶</td>\n",
       "      <td>深圳</td>\n",
       "      <td>46.90</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.87</td>\n",
       "      <td>26369.38</td>\n",
       "      <td>23502.03</td>\n",
       "      <td>1737.75</td>\n",
       "      <td>9434.82</td>\n",
       "      <td>...</td>\n",
       "      <td>3.37</td>\n",
       "      <td>9.88</td>\n",
       "      <td>20171208</td>\n",
       "      <td>5390.14</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>48.54</td>\n",
       "      <td>25.94</td>\n",
       "      <td>45956.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300688</th>\n",
       "      <td>创业黑马</td>\n",
       "      <td>综合类</td>\n",
       "      <td>北京</td>\n",
       "      <td>153.49</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.68</td>\n",
       "      <td>41396.55</td>\n",
       "      <td>40351.37</td>\n",
       "      <td>380.64</td>\n",
       "      <td>21506.17</td>\n",
       "      <td>...</td>\n",
       "      <td>5.14</td>\n",
       "      <td>12.66</td>\n",
       "      <td>20170810</td>\n",
       "      <td>6212.93</td>\n",
       "      <td>0.91</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>56.91</td>\n",
       "      <td>17.97</td>\n",
       "      <td>15720.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002922</th>\n",
       "      <td>伊戈尔</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>广东</td>\n",
       "      <td>46.52</td>\n",
       "      <td>0.33</td>\n",
       "      <td>1.32</td>\n",
       "      <td>94519.70</td>\n",
       "      <td>58731.76</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>5.00</td>\n",
       "      <td>5.28</td>\n",
       "      <td>20171229</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>7.03</td>\n",
       "      <td>65639.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300490</th>\n",
       "      <td>华自科技</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>湖南</td>\n",
       "      <td>100.42</td>\n",
       "      <td>0.91</td>\n",
       "      <td>2.29</td>\n",
       "      <td>95275.47</td>\n",
       "      <td>59965.38</td>\n",
       "      <td>11950.71</td>\n",
       "      <td>23825.85</td>\n",
       "      <td>...</td>\n",
       "      <td>3.14</td>\n",
       "      <td>4.78</td>\n",
       "      <td>20151231</td>\n",
       "      <td>17474.20</td>\n",
       "      <td>0.76</td>\n",
       "      <td>1.29</td>\n",
       "      <td>-7.52</td>\n",
       "      <td>39.56</td>\n",
       "      <td>7.49</td>\n",
       "      <td>17168.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000672</th>\n",
       "      <td>上峰水泥</td>\n",
       "      <td>水泥</td>\n",
       "      <td>甘肃</td>\n",
       "      <td>18.65</td>\n",
       "      <td>8.14</td>\n",
       "      <td>8.14</td>\n",
       "      <td>624103.44</td>\n",
       "      <td>265314.13</td>\n",
       "      <td>227190.45</td>\n",
       "      <td>-97110.06</td>\n",
       "      <td>...</td>\n",
       "      <td>2.32</td>\n",
       "      <td>5.99</td>\n",
       "      <td>19961218</td>\n",
       "      <td>180510.67</td>\n",
       "      <td>2.22</td>\n",
       "      <td>37.93</td>\n",
       "      <td>456.55</td>\n",
       "      <td>32.35</td>\n",
       "      <td>15.50</td>\n",
       "      <td>70300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002853</th>\n",
       "      <td>皮阿诺</td>\n",
       "      <td>家居用品</td>\n",
       "      <td>广东</td>\n",
       "      <td>53.34</td>\n",
       "      <td>0.53</td>\n",
       "      <td>1.55</td>\n",
       "      <td>126108.92</td>\n",
       "      <td>96820.03</td>\n",
       "      <td>15414.80</td>\n",
       "      <td>48838.14</td>\n",
       "      <td>...</td>\n",
       "      <td>5.26</td>\n",
       "      <td>6.08</td>\n",
       "      <td>20170310</td>\n",
       "      <td>23739.42</td>\n",
       "      <td>1.53</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>35.00</td>\n",
       "      <td>12.61</td>\n",
       "      <td>28539.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002629</th>\n",
       "      <td>仁智股份</td>\n",
       "      <td>石油开采</td>\n",
       "      <td>浙江</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.44</td>\n",
       "      <td>4.12</td>\n",
       "      <td>77336.45</td>\n",
       "      <td>56109.20</td>\n",
       "      <td>6371.80</td>\n",
       "      <td>8860.48</td>\n",
       "      <td>...</td>\n",
       "      <td>1.61</td>\n",
       "      <td>4.72</td>\n",
       "      <td>20111103</td>\n",
       "      <td>12802.07</td>\n",
       "      <td>0.31</td>\n",
       "      <td>2306.35</td>\n",
       "      <td>70.91</td>\n",
       "      <td>2.03</td>\n",
       "      <td>-0.49</td>\n",
       "      <td>31087.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600801</th>\n",
       "      <td>华新水泥</td>\n",
       "      <td>水泥</td>\n",
       "      <td>湖北</td>\n",
       "      <td>16.32</td>\n",
       "      <td>9.73</td>\n",
       "      <td>14.98</td>\n",
       "      <td>2935200.50</td>\n",
       "      <td>789854.69</td>\n",
       "      <td>1591451.38</td>\n",
       "      <td>251120.30</td>\n",
       "      <td>...</td>\n",
       "      <td>7.26</td>\n",
       "      <td>2.10</td>\n",
       "      <td>19940103</td>\n",
       "      <td>629597.56</td>\n",
       "      <td>4.20</td>\n",
       "      <td>56.60</td>\n",
       "      <td>552.79</td>\n",
       "      <td>26.35</td>\n",
       "      <td>7.32</td>\n",
       "      <td>65841.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002596</th>\n",
       "      <td>海南瑞泽</td>\n",
       "      <td>其他建材</td>\n",
       "      <td>海南</td>\n",
       "      <td>90.76</td>\n",
       "      <td>7.26</td>\n",
       "      <td>10.74</td>\n",
       "      <td>433028.91</td>\n",
       "      <td>268482.38</td>\n",
       "      <td>58270.35</td>\n",
       "      <td>64013.75</td>\n",
       "      <td>...</td>\n",
       "      <td>2.34</td>\n",
       "      <td>5.07</td>\n",
       "      <td>20110707</td>\n",
       "      <td>57144.15</td>\n",
       "      <td>0.53</td>\n",
       "      <td>72.11</td>\n",
       "      <td>537.48</td>\n",
       "      <td>18.51</td>\n",
       "      <td>5.47</td>\n",
       "      <td>21598.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603778</th>\n",
       "      <td>乾景园林</td>\n",
       "      <td>建筑施工</td>\n",
       "      <td>北京</td>\n",
       "      <td>84.72</td>\n",
       "      <td>2.26</td>\n",
       "      <td>5.00</td>\n",
       "      <td>163372.88</td>\n",
       "      <td>160503.88</td>\n",
       "      <td>993.25</td>\n",
       "      <td>2313.55</td>\n",
       "      <td>...</td>\n",
       "      <td>1.92</td>\n",
       "      <td>3.93</td>\n",
       "      <td>20151231</td>\n",
       "      <td>39647.64</td>\n",
       "      <td>0.79</td>\n",
       "      <td>-2.90</td>\n",
       "      <td>-32.97</td>\n",
       "      <td>23.82</td>\n",
       "      <td>10.89</td>\n",
       "      <td>35005.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601636</th>\n",
       "      <td>旗滨集团</td>\n",
       "      <td>玻璃</td>\n",
       "      <td>湖南</td>\n",
       "      <td>17.57</td>\n",
       "      <td>25.13</td>\n",
       "      <td>26.91</td>\n",
       "      <td>1295578.63</td>\n",
       "      <td>256674.52</td>\n",
       "      <td>804140.13</td>\n",
       "      <td>171494.67</td>\n",
       "      <td>...</td>\n",
       "      <td>2.49</td>\n",
       "      <td>2.88</td>\n",
       "      <td>20110812</td>\n",
       "      <td>237574.80</td>\n",
       "      <td>0.88</td>\n",
       "      <td>15.88</td>\n",
       "      <td>90.89</td>\n",
       "      <td>33.02</td>\n",
       "      <td>15.02</td>\n",
       "      <td>63251.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300737</th>\n",
       "      <td>科顺股份</td>\n",
       "      <td>其他建材</td>\n",
       "      <td>广东</td>\n",
       "      <td>46.50</td>\n",
       "      <td>1.53</td>\n",
       "      <td>6.11</td>\n",
       "      <td>240643.55</td>\n",
       "      <td>171179.17</td>\n",
       "      <td>26359.14</td>\n",
       "      <td>58892.38</td>\n",
       "      <td>...</td>\n",
       "      <td>3.15</td>\n",
       "      <td>5.39</td>\n",
       "      <td>20180125</td>\n",
       "      <td>29041.74</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>38.34</td>\n",
       "      <td>11.81</td>\n",
       "      <td>281200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300104</th>\n",
       "      <td>乐视网</td>\n",
       "      <td>互联网</td>\n",
       "      <td>北京</td>\n",
       "      <td>0.00</td>\n",
       "      <td>30.43</td>\n",
       "      <td>39.89</td>\n",
       "      <td>3228806.25</td>\n",
       "      <td>1410543.63</td>\n",
       "      <td>104074.28</td>\n",
       "      <td>820496.19</td>\n",
       "      <td>...</td>\n",
       "      <td>3.13</td>\n",
       "      <td>2.11</td>\n",
       "      <td>20100812</td>\n",
       "      <td>-189.08</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-63.67</td>\n",
       "      <td>-435.02</td>\n",
       "      <td>-16.19</td>\n",
       "      <td>-27.10</td>\n",
       "      <td>185875.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000789</th>\n",
       "      <td>万年青</td>\n",
       "      <td>水泥</td>\n",
       "      <td>江西</td>\n",
       "      <td>24.61</td>\n",
       "      <td>6.13</td>\n",
       "      <td>6.13</td>\n",
       "      <td>845172.88</td>\n",
       "      <td>293580.13</td>\n",
       "      <td>405676.72</td>\n",
       "      <td>24090.26</td>\n",
       "      <td>...</td>\n",
       "      <td>4.69</td>\n",
       "      <td>2.67</td>\n",
       "      <td>19970923</td>\n",
       "      <td>186275.22</td>\n",
       "      <td>3.04</td>\n",
       "      <td>24.30</td>\n",
       "      <td>41.18</td>\n",
       "      <td>22.33</td>\n",
       "      <td>5.07</td>\n",
       "      <td>41902.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300727</th>\n",
       "      <td>润禾材料</td>\n",
       "      <td>化工原料</td>\n",
       "      <td>浙江</td>\n",
       "      <td>73.74</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.98</td>\n",
       "      <td>43196.92</td>\n",
       "      <td>25291.61</td>\n",
       "      <td>12968.00</td>\n",
       "      <td>10365.67</td>\n",
       "      <td>...</td>\n",
       "      <td>4.76</td>\n",
       "      <td>7.33</td>\n",
       "      <td>20171127</td>\n",
       "      <td>8362.07</td>\n",
       "      <td>0.86</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.56</td>\n",
       "      <td>10.75</td>\n",
       "      <td>50562.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002687</th>\n",
       "      <td>乔治白</td>\n",
       "      <td>服饰</td>\n",
       "      <td>浙江</td>\n",
       "      <td>41.26</td>\n",
       "      <td>3.19</td>\n",
       "      <td>3.55</td>\n",
       "      <td>136680.20</td>\n",
       "      <td>64897.92</td>\n",
       "      <td>51680.75</td>\n",
       "      <td>36338.87</td>\n",
       "      <td>...</td>\n",
       "      <td>2.86</td>\n",
       "      <td>2.52</td>\n",
       "      <td>20120713</td>\n",
       "      <td>19871.05</td>\n",
       "      <td>0.56</td>\n",
       "      <td>5.49</td>\n",
       "      <td>5.13</td>\n",
       "      <td>45.30</td>\n",
       "      <td>8.54</td>\n",
       "      <td>27602.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600802</th>\n",
       "      <td>福建水泥</td>\n",
       "      <td>水泥</td>\n",
       "      <td>福建</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.82</td>\n",
       "      <td>3.82</td>\n",
       "      <td>430350.91</td>\n",
       "      <td>66504.81</td>\n",
       "      <td>237439.88</td>\n",
       "      <td>21390.35</td>\n",
       "      <td>...</td>\n",
       "      <td>1.80</td>\n",
       "      <td>4.25</td>\n",
       "      <td>19940103</td>\n",
       "      <td>-34063.92</td>\n",
       "      <td>-0.89</td>\n",
       "      <td>45.44</td>\n",
       "      <td>-9.33</td>\n",
       "      <td>10.55</td>\n",
       "      <td>-6.85</td>\n",
       "      <td>47463.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603680</th>\n",
       "      <td>今创集团</td>\n",
       "      <td>运输设备</td>\n",
       "      <td>江苏</td>\n",
       "      <td>37.91</td>\n",
       "      <td>0.42</td>\n",
       "      <td>4.20</td>\n",
       "      <td>549317.25</td>\n",
       "      <td>394765.72</td>\n",
       "      <td>58971.98</td>\n",
       "      <td>43780.80</td>\n",
       "      <td>...</td>\n",
       "      <td>5.04</td>\n",
       "      <td>9.60</td>\n",
       "      <td>20180227</td>\n",
       "      <td>83832.84</td>\n",
       "      <td>2.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>38.62</td>\n",
       "      <td>19.57</td>\n",
       "      <td>40917.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300643</th>\n",
       "      <td>万通智控</td>\n",
       "      <td>汽车配件</td>\n",
       "      <td>浙江</td>\n",
       "      <td>66.59</td>\n",
       "      <td>0.50</td>\n",
       "      <td>2.00</td>\n",
       "      <td>47352.26</td>\n",
       "      <td>34694.26</td>\n",
       "      <td>7265.92</td>\n",
       "      <td>13293.52</td>\n",
       "      <td>...</td>\n",
       "      <td>2.03</td>\n",
       "      <td>6.40</td>\n",
       "      <td>20170505</td>\n",
       "      <td>6597.15</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>31.97</td>\n",
       "      <td>12.60</td>\n",
       "      <td>22522.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603356</th>\n",
       "      <td>华菱精工</td>\n",
       "      <td>机械基件</td>\n",
       "      <td>安徽</td>\n",
       "      <td>56.48</td>\n",
       "      <td>0.33</td>\n",
       "      <td>1.33</td>\n",
       "      <td>52746.38</td>\n",
       "      <td>32024.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>3.30</td>\n",
       "      <td>8.33</td>\n",
       "      <td>20180124</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10.20</td>\n",
       "      <td>33471.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300298</th>\n",
       "      <td>三诺生物</td>\n",
       "      <td>医疗保健</td>\n",
       "      <td>湖南</td>\n",
       "      <td>36.08</td>\n",
       "      <td>4.05</td>\n",
       "      <td>4.71</td>\n",
       "      <td>155707.02</td>\n",
       "      <td>71815.38</td>\n",
       "      <td>23339.95</td>\n",
       "      <td>33934.82</td>\n",
       "      <td>...</td>\n",
       "      <td>3.39</td>\n",
       "      <td>6.33</td>\n",
       "      <td>20120319</td>\n",
       "      <td>46851.32</td>\n",
       "      <td>0.99</td>\n",
       "      <td>35.08</td>\n",
       "      <td>76.35</td>\n",
       "      <td>66.31</td>\n",
       "      <td>27.52</td>\n",
       "      <td>10839.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603019</th>\n",
       "      <td>中科曙光</td>\n",
       "      <td>电脑设备</td>\n",
       "      <td>天津</td>\n",
       "      <td>310.76</td>\n",
       "      <td>6.43</td>\n",
       "      <td>6.43</td>\n",
       "      <td>895743.69</td>\n",
       "      <td>637031.06</td>\n",
       "      <td>84122.65</td>\n",
       "      <td>157540.70</td>\n",
       "      <td>...</td>\n",
       "      <td>4.54</td>\n",
       "      <td>10.74</td>\n",
       "      <td>20141106</td>\n",
       "      <td>64837.63</td>\n",
       "      <td>1.01</td>\n",
       "      <td>43.15</td>\n",
       "      <td>1.53</td>\n",
       "      <td>17.22</td>\n",
       "      <td>2.00</td>\n",
       "      <td>66635.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600789</th>\n",
       "      <td>鲁抗医药</td>\n",
       "      <td>化学制药</td>\n",
       "      <td>山东</td>\n",
       "      <td>104.22</td>\n",
       "      <td>5.82</td>\n",
       "      <td>5.82</td>\n",
       "      <td>477946.09</td>\n",
       "      <td>194251.61</td>\n",
       "      <td>160819.11</td>\n",
       "      <td>109587.92</td>\n",
       "      <td>...</td>\n",
       "      <td>3.25</td>\n",
       "      <td>3.21</td>\n",
       "      <td>19970226</td>\n",
       "      <td>5917.60</td>\n",
       "      <td>0.10</td>\n",
       "      <td>3.87</td>\n",
       "      <td>101.73</td>\n",
       "      <td>25.38</td>\n",
       "      <td>2.31</td>\n",
       "      <td>111040.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300431</th>\n",
       "      <td>暴风集团</td>\n",
       "      <td>互联网</td>\n",
       "      <td>北京</td>\n",
       "      <td>340.35</td>\n",
       "      <td>2.35</td>\n",
       "      <td>3.32</td>\n",
       "      <td>250824.84</td>\n",
       "      <td>146162.69</td>\n",
       "      <td>4464.83</td>\n",
       "      <td>31970.78</td>\n",
       "      <td>...</td>\n",
       "      <td>2.73</td>\n",
       "      <td>10.15</td>\n",
       "      <td>20150324</td>\n",
       "      <td>34673.92</td>\n",
       "      <td>1.04</td>\n",
       "      <td>41.99</td>\n",
       "      <td>4.60</td>\n",
       "      <td>20.92</td>\n",
       "      <td>1.59</td>\n",
       "      <td>78925.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300561</th>\n",
       "      <td>汇金科技</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>广东</td>\n",
       "      <td>59.68</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.85</td>\n",
       "      <td>67706.06</td>\n",
       "      <td>64048.53</td>\n",
       "      <td>1469.56</td>\n",
       "      <td>33176.40</td>\n",
       "      <td>...</td>\n",
       "      <td>8.03</td>\n",
       "      <td>5.14</td>\n",
       "      <td>20161117</td>\n",
       "      <td>20041.60</td>\n",
       "      <td>2.35</td>\n",
       "      <td>-8.43</td>\n",
       "      <td>-25.68</td>\n",
       "      <td>72.22</td>\n",
       "      <td>32.68</td>\n",
       "      <td>10943.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300677</th>\n",
       "      <td>英科医疗</td>\n",
       "      <td>医疗保健</td>\n",
       "      <td>山东</td>\n",
       "      <td>49.02</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.98</td>\n",
       "      <td>165823.69</td>\n",
       "      <td>85487.75</td>\n",
       "      <td>63891.05</td>\n",
       "      <td>70667.90</td>\n",
       "      <td>...</td>\n",
       "      <td>11.07</td>\n",
       "      <td>6.54</td>\n",
       "      <td>20170721</td>\n",
       "      <td>29952.25</td>\n",
       "      <td>3.05</td>\n",
       "      <td>47.96</td>\n",
       "      <td>68.61</td>\n",
       "      <td>24.92</td>\n",
       "      <td>8.29</td>\n",
       "      <td>11500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300066</th>\n",
       "      <td>三川智慧</td>\n",
       "      <td>电器仪表</td>\n",
       "      <td>江西</td>\n",
       "      <td>57.87</td>\n",
       "      <td>9.49</td>\n",
       "      <td>10.40</td>\n",
       "      <td>177507.34</td>\n",
       "      <td>108423.67</td>\n",
       "      <td>27638.00</td>\n",
       "      <td>6751.46</td>\n",
       "      <td>...</td>\n",
       "      <td>1.46</td>\n",
       "      <td>3.23</td>\n",
       "      <td>20100326</td>\n",
       "      <td>31031.15</td>\n",
       "      <td>0.30</td>\n",
       "      <td>-13.71</td>\n",
       "      <td>-44.00</td>\n",
       "      <td>33.95</td>\n",
       "      <td>14.97</td>\n",
       "      <td>52798.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300166</th>\n",
       "      <td>东方国信</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>北京</td>\n",
       "      <td>83.67</td>\n",
       "      <td>8.06</td>\n",
       "      <td>10.50</td>\n",
       "      <td>468344.94</td>\n",
       "      <td>273063.00</td>\n",
       "      <td>22614.40</td>\n",
       "      <td>210379.02</td>\n",
       "      <td>...</td>\n",
       "      <td>4.23</td>\n",
       "      <td>3.95</td>\n",
       "      <td>20110125</td>\n",
       "      <td>97738.21</td>\n",
       "      <td>0.93</td>\n",
       "      <td>18.86</td>\n",
       "      <td>30.89</td>\n",
       "      <td>45.86</td>\n",
       "      <td>19.72</td>\n",
       "      <td>30680.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600093</th>\n",
       "      <td>易见股份</td>\n",
       "      <td>汽车配件</td>\n",
       "      <td>四川</td>\n",
       "      <td>21.75</td>\n",
       "      <td>3.22</td>\n",
       "      <td>11.22</td>\n",
       "      <td>1329209.88</td>\n",
       "      <td>1256731.63</td>\n",
       "      <td>375.16</td>\n",
       "      <td>403888.31</td>\n",
       "      <td>...</td>\n",
       "      <td>5.77</td>\n",
       "      <td>2.75</td>\n",
       "      <td>19970626</td>\n",
       "      <td>121363.10</td>\n",
       "      <td>1.08</td>\n",
       "      <td>-12.56</td>\n",
       "      <td>37.96</td>\n",
       "      <td>7.29</td>\n",
       "      <td>6.33</td>\n",
       "      <td>30574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300663</th>\n",
       "      <td>科蓝软件</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>北京</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.33</td>\n",
       "      <td>1.34</td>\n",
       "      <td>100504.81</td>\n",
       "      <td>95675.75</td>\n",
       "      <td>207.80</td>\n",
       "      <td>37248.46</td>\n",
       "      <td>...</td>\n",
       "      <td>4.38</td>\n",
       "      <td>6.53</td>\n",
       "      <td>20170608</td>\n",
       "      <td>5791.01</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>34.29</td>\n",
       "      <td>-21.19</td>\n",
       "      <td>15286.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300685</th>\n",
       "      <td>艾德生物</td>\n",
       "      <td>生物制药</td>\n",
       "      <td>福建</td>\n",
       "      <td>87.75</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.80</td>\n",
       "      <td>67973.31</td>\n",
       "      <td>53230.90</td>\n",
       "      <td>12764.17</td>\n",
       "      <td>39687.85</td>\n",
       "      <td>...</td>\n",
       "      <td>7.79</td>\n",
       "      <td>12.74</td>\n",
       "      <td>20170802</td>\n",
       "      <td>13857.11</td>\n",
       "      <td>1.73</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>92.28</td>\n",
       "      <td>27.97</td>\n",
       "      <td>14639.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002879</th>\n",
       "      <td>长缆科技</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>湖南</td>\n",
       "      <td>39.52</td>\n",
       "      <td>0.35</td>\n",
       "      <td>1.38</td>\n",
       "      <td>165723.11</td>\n",
       "      <td>140471.88</td>\n",
       "      <td>18471.20</td>\n",
       "      <td>76383.56</td>\n",
       "      <td>...</td>\n",
       "      <td>9.92</td>\n",
       "      <td>3.57</td>\n",
       "      <td>20170707</td>\n",
       "      <td>41488.32</td>\n",
       "      <td>3.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>56.40</td>\n",
       "      <td>20.62</td>\n",
       "      <td>21318.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601360</th>\n",
       "      <td>三六零</td>\n",
       "      <td>互联网</td>\n",
       "      <td>江苏</td>\n",
       "      <td>4951.11</td>\n",
       "      <td>3.97</td>\n",
       "      <td>67.64</td>\n",
       "      <td>262470.53</td>\n",
       "      <td>177465.42</td>\n",
       "      <td>50503.34</td>\n",
       "      <td>33821.80</td>\n",
       "      <td>...</td>\n",
       "      <td>4.27</td>\n",
       "      <td>11.68</td>\n",
       "      <td>20120116</td>\n",
       "      <td>80955.68</td>\n",
       "      <td>0.12</td>\n",
       "      <td>-9.63</td>\n",
       "      <td>-57.28</td>\n",
       "      <td>29.62</td>\n",
       "      <td>3.12</td>\n",
       "      <td>76200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002912</th>\n",
       "      <td>中新赛克</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>深圳</td>\n",
       "      <td>64.73</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.67</td>\n",
       "      <td>95634.96</td>\n",
       "      <td>77540.45</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>17.08</td>\n",
       "      <td>7.22</td>\n",
       "      <td>20171121</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>31.45</td>\n",
       "      <td>12930.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300684</th>\n",
       "      <td>中石科技</td>\n",
       "      <td>化工原料</td>\n",
       "      <td>北京</td>\n",
       "      <td>123.23</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.87</td>\n",
       "      <td>61019.13</td>\n",
       "      <td>33648.35</td>\n",
       "      <td>24754.74</td>\n",
       "      <td>12281.78</td>\n",
       "      <td>...</td>\n",
       "      <td>5.45</td>\n",
       "      <td>10.30</td>\n",
       "      <td>20171227</td>\n",
       "      <td>15325.42</td>\n",
       "      <td>1.76</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>34.84</td>\n",
       "      <td>10.49</td>\n",
       "      <td>45590.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300542</th>\n",
       "      <td>新晨科技</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>北京</td>\n",
       "      <td>225.82</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.91</td>\n",
       "      <td>69790.55</td>\n",
       "      <td>58459.45</td>\n",
       "      <td>1190.14</td>\n",
       "      <td>22247.15</td>\n",
       "      <td>...</td>\n",
       "      <td>6.22</td>\n",
       "      <td>5.59</td>\n",
       "      <td>20160920</td>\n",
       "      <td>24093.03</td>\n",
       "      <td>2.64</td>\n",
       "      <td>41.06</td>\n",
       "      <td>8.85</td>\n",
       "      <td>22.48</td>\n",
       "      <td>2.78</td>\n",
       "      <td>13816.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300314</th>\n",
       "      <td>戴维医疗</td>\n",
       "      <td>医疗保健</td>\n",
       "      <td>浙江</td>\n",
       "      <td>58.39</td>\n",
       "      <td>1.89</td>\n",
       "      <td>2.88</td>\n",
       "      <td>85160.25</td>\n",
       "      <td>50522.89</td>\n",
       "      <td>22282.18</td>\n",
       "      <td>17553.43</td>\n",
       "      <td>...</td>\n",
       "      <td>2.72</td>\n",
       "      <td>4.99</td>\n",
       "      <td>20120508</td>\n",
       "      <td>27732.10</td>\n",
       "      <td>0.96</td>\n",
       "      <td>21.95</td>\n",
       "      <td>6.12</td>\n",
       "      <td>52.74</td>\n",
       "      <td>23.62</td>\n",
       "      <td>23140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600588</th>\n",
       "      <td>用友网络</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>北京</td>\n",
       "      <td>0.00</td>\n",
       "      <td>14.60</td>\n",
       "      <td>14.64</td>\n",
       "      <td>1305918.13</td>\n",
       "      <td>671876.31</td>\n",
       "      <td>198737.13</td>\n",
       "      <td>221988.27</td>\n",
       "      <td>...</td>\n",
       "      <td>3.50</td>\n",
       "      <td>10.30</td>\n",
       "      <td>20010518</td>\n",
       "      <td>89537.00</td>\n",
       "      <td>0.61</td>\n",
       "      <td>24.41</td>\n",
       "      <td>26.69</td>\n",
       "      <td>64.97</td>\n",
       "      <td>-7.94</td>\n",
       "      <td>68068.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601700</th>\n",
       "      <td>风范股份</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>江苏</td>\n",
       "      <td>36.22</td>\n",
       "      <td>11.33</td>\n",
       "      <td>11.33</td>\n",
       "      <td>458216.19</td>\n",
       "      <td>293546.72</td>\n",
       "      <td>40695.48</td>\n",
       "      <td>122509.51</td>\n",
       "      <td>...</td>\n",
       "      <td>2.66</td>\n",
       "      <td>2.51</td>\n",
       "      <td>20110118</td>\n",
       "      <td>41645.55</td>\n",
       "      <td>0.37</td>\n",
       "      <td>-21.90</td>\n",
       "      <td>-9.97</td>\n",
       "      <td>19.78</td>\n",
       "      <td>8.98</td>\n",
       "      <td>71668.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600634</th>\n",
       "      <td>富控互动</td>\n",
       "      <td>互联网</td>\n",
       "      <td>上海</td>\n",
       "      <td>90.40</td>\n",
       "      <td>5.76</td>\n",
       "      <td>5.76</td>\n",
       "      <td>654017.44</td>\n",
       "      <td>366004.97</td>\n",
       "      <td>2749.05</td>\n",
       "      <td>193459.88</td>\n",
       "      <td>...</td>\n",
       "      <td>5.15</td>\n",
       "      <td>2.75</td>\n",
       "      <td>19930304</td>\n",
       "      <td>39187.15</td>\n",
       "      <td>0.68</td>\n",
       "      <td>-72.23</td>\n",
       "      <td>62.32</td>\n",
       "      <td>81.69</td>\n",
       "      <td>10.87</td>\n",
       "      <td>37100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300504</th>\n",
       "      <td>天邑股份</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>四川</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>196783.86</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>31.67</td>\n",
       "      <td>51.32</td>\n",
       "      <td>0.00</td>\n",
       "      <td>9.76</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002931</th>\n",
       "      <td>锋龙股份</td>\n",
       "      <td>汽车配件</td>\n",
       "      <td>浙江</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33967.37</td>\n",
       "      <td>20617.76</td>\n",
       "      <td>10713.78</td>\n",
       "      <td>5462.35</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>9271.44</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24.62</td>\n",
       "      <td>12.35</td>\n",
       "      <td>35.62</td>\n",
       "      <td>15.26</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000950</th>\n",
       "      <td>*ST建峰</td>\n",
       "      <td>农药化肥</td>\n",
       "      <td>重庆</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.99</td>\n",
       "      <td>17.28</td>\n",
       "      <td>1562395.13</td>\n",
       "      <td>1296451.63</td>\n",
       "      <td>48986.46</td>\n",
       "      <td>259775.59</td>\n",
       "      <td>...</td>\n",
       "      <td>3.80</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19990916</td>\n",
       "      <td>193228.36</td>\n",
       "      <td>1.12</td>\n",
       "      <td>1.16</td>\n",
       "      <td>758.44</td>\n",
       "      <td>9.07</td>\n",
       "      <td>5.20</td>\n",
       "      <td>30624.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000629</th>\n",
       "      <td>*ST钒钛</td>\n",
       "      <td>普钢</td>\n",
       "      <td>四川</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47.67</td>\n",
       "      <td>85.90</td>\n",
       "      <td>999802.19</td>\n",
       "      <td>379422.75</td>\n",
       "      <td>442935.09</td>\n",
       "      <td>552790.38</td>\n",
       "      <td>...</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19961115</td>\n",
       "      <td>-1146276.50</td>\n",
       "      <td>-1.33</td>\n",
       "      <td>-29.09</td>\n",
       "      <td>155.19</td>\n",
       "      <td>20.06</td>\n",
       "      <td>10.35</td>\n",
       "      <td>309056.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000511</th>\n",
       "      <td>*ST烯碳</td>\n",
       "      <td>矿物制品</td>\n",
       "      <td>辽宁</td>\n",
       "      <td>0.00</td>\n",
       "      <td>11.55</td>\n",
       "      <td>11.55</td>\n",
       "      <td>346274.91</td>\n",
       "      <td>312833.03</td>\n",
       "      <td>2405.45</td>\n",
       "      <td>29655.31</td>\n",
       "      <td>...</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19930518</td>\n",
       "      <td>-63425.48</td>\n",
       "      <td>-0.55</td>\n",
       "      <td>43.62</td>\n",
       "      <td>-55.46</td>\n",
       "      <td>0.22</td>\n",
       "      <td>-14.68</td>\n",
       "      <td>164822.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603214</th>\n",
       "      <td>爱婴室</td>\n",
       "      <td>百货</td>\n",
       "      <td>上海</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>76961.15</td>\n",
       "      <td>61297.16</td>\n",
       "      <td>7078.72</td>\n",
       "      <td>2911.81</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>25456.17</td>\n",
       "      <td>0.00</td>\n",
       "      <td>14.06</td>\n",
       "      <td>26.47</td>\n",
       "      <td>28.41</td>\n",
       "      <td>5.18</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600929</th>\n",
       "      <td>湖南盐业</td>\n",
       "      <td>食品</td>\n",
       "      <td>湖南</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>310491.63</td>\n",
       "      <td>78859.31</td>\n",
       "      <td>139873.81</td>\n",
       "      <td>24281.50</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>71625.13</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.30</td>\n",
       "      <td>15.06</td>\n",
       "      <td>47.71</td>\n",
       "      <td>7.24</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600806</th>\n",
       "      <td>*ST昆机</td>\n",
       "      <td>机床制造</td>\n",
       "      <td>云南</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.90</td>\n",
       "      <td>5.31</td>\n",
       "      <td>193646.66</td>\n",
       "      <td>121889.97</td>\n",
       "      <td>45542.53</td>\n",
       "      <td>1976.50</td>\n",
       "      <td>...</td>\n",
       "      <td>0.41</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19940103</td>\n",
       "      <td>-45091.93</td>\n",
       "      <td>-0.85</td>\n",
       "      <td>21.07</td>\n",
       "      <td>-23.37</td>\n",
       "      <td>3.60</td>\n",
       "      <td>-51.43</td>\n",
       "      <td>33099.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600432</th>\n",
       "      <td>*ST吉恩</td>\n",
       "      <td>小金属</td>\n",
       "      <td>吉林</td>\n",
       "      <td>0.00</td>\n",
       "      <td>16.04</td>\n",
       "      <td>16.04</td>\n",
       "      <td>1373541.75</td>\n",
       "      <td>297409.28</td>\n",
       "      <td>768094.25</td>\n",
       "      <td>626871.94</td>\n",
       "      <td>...</td>\n",
       "      <td>0.88</td>\n",
       "      <td>0.00</td>\n",
       "      <td>20030905</td>\n",
       "      <td>-549617.19</td>\n",
       "      <td>-3.43</td>\n",
       "      <td>9.91</td>\n",
       "      <td>-56.24</td>\n",
       "      <td>15.12</td>\n",
       "      <td>-42.86</td>\n",
       "      <td>70654.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3505 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         name industry area       pe  outstanding  totals  totalAssets  \\\n",
       "code                                                                     \n",
       "600249    两面针     日用化工   广西     0.00         5.50    5.50    323929.22   \n",
       "000795    英洛华     矿物制品   山西    71.17         6.86   11.34    262512.06   \n",
       "000151   中成股份     商贸代理   北京    45.23         2.67    2.96    230761.38   \n",
       "002208   合肥城建     区域地产   安徽   148.56         3.19    3.20   1160278.00   \n",
       "300655   晶瑞股份     化工原料   江苏    87.70         0.22    0.88     71158.15   \n",
       "300523   辰安科技     软件服务   北京  3536.31         1.01    1.44    114180.32   \n",
       "603506   南都物业     房产服务   浙江    51.14         0.20    0.79     72642.00   \n",
       "300732    设研院     建筑施工   河南    39.73         0.18    0.72    147598.91   \n",
       "600405    动力源     电气设备   北京     0.00         5.53    5.62    297222.53   \n",
       "300647    超频三      元器件   深圳    78.98         0.30    1.23     83115.93   \n",
       "603712    七一二     通信设备   天津   155.04         1.00    7.72    348015.50   \n",
       "300731   科创新源       橡胶   深圳    46.90         0.22    0.87     26369.38   \n",
       "300688   创业黑马      综合类   北京   153.49         0.17    0.68     41396.55   \n",
       "002922    伊戈尔     电气设备   广东    46.52         0.33    1.32     94519.70   \n",
       "300490   华自科技     电气设备   湖南   100.42         0.91    2.29     95275.47   \n",
       "000672   上峰水泥       水泥   甘肃    18.65         8.14    8.14    624103.44   \n",
       "002853    皮阿诺     家居用品   广东    53.34         0.53    1.55    126108.92   \n",
       "002629   仁智股份     石油开采   浙江     0.00         3.44    4.12     77336.45   \n",
       "600801   华新水泥       水泥   湖北    16.32         9.73   14.98   2935200.50   \n",
       "002596   海南瑞泽     其他建材   海南    90.76         7.26   10.74    433028.91   \n",
       "603778   乾景园林     建筑施工   北京    84.72         2.26    5.00    163372.88   \n",
       "601636   旗滨集团       玻璃   湖南    17.57        25.13   26.91   1295578.63   \n",
       "300737   科顺股份     其他建材   广东    46.50         1.53    6.11    240643.55   \n",
       "300104    乐视网      互联网   北京     0.00        30.43   39.89   3228806.25   \n",
       "000789    万年青       水泥   江西    24.61         6.13    6.13    845172.88   \n",
       "300727   润禾材料     化工原料   浙江    73.74         0.24    0.98     43196.92   \n",
       "002687    乔治白       服饰   浙江    41.26         3.19    3.55    136680.20   \n",
       "600802   福建水泥       水泥   福建     0.00         3.82    3.82    430350.91   \n",
       "603680   今创集团     运输设备   江苏    37.91         0.42    4.20    549317.25   \n",
       "300643   万通智控     汽车配件   浙江    66.59         0.50    2.00     47352.26   \n",
       "...       ...      ...  ...      ...          ...     ...          ...   \n",
       "603356   华菱精工     机械基件   安徽    56.48         0.33    1.33     52746.38   \n",
       "300298   三诺生物     医疗保健   湖南    36.08         4.05    4.71    155707.02   \n",
       "603019   中科曙光     电脑设备   天津   310.76         6.43    6.43    895743.69   \n",
       "600789   鲁抗医药     化学制药   山东   104.22         5.82    5.82    477946.09   \n",
       "300431   暴风集团      互联网   北京   340.35         2.35    3.32    250824.84   \n",
       "300561   汇金科技     软件服务   广东    59.68         0.34    0.85     67706.06   \n",
       "300677   英科医疗     医疗保健   山东    49.02         0.24    0.98    165823.69   \n",
       "300066   三川智慧     电器仪表   江西    57.87         9.49   10.40    177507.34   \n",
       "300166   东方国信     软件服务   北京    83.67         8.06   10.50    468344.94   \n",
       "600093   易见股份     汽车配件   四川    21.75         3.22   11.22   1329209.88   \n",
       "300663   科蓝软件     软件服务   北京     0.00         0.33    1.34    100504.81   \n",
       "300685   艾德生物     生物制药   福建    87.75         0.20    0.80     67973.31   \n",
       "002879   长缆科技     电气设备   湖南    39.52         0.35    1.38    165723.11   \n",
       "601360    三六零      互联网   江苏  4951.11         3.97   67.64    262470.53   \n",
       "002912   中新赛克     软件服务   深圳    64.73         0.17    0.67     95634.96   \n",
       "300684   中石科技     化工原料   北京   123.23         0.22    0.87     61019.13   \n",
       "300542   新晨科技     软件服务   北京   225.82         0.33    0.91     69790.55   \n",
       "300314   戴维医疗     医疗保健   浙江    58.39         1.89    2.88     85160.25   \n",
       "600588   用友网络     软件服务   北京     0.00        14.60   14.64   1305918.13   \n",
       "601700   风范股份     电气设备   江苏    36.22        11.33   11.33    458216.19   \n",
       "600634   富控互动      互联网   上海    90.40         5.76    5.76    654017.44   \n",
       "300504   天邑股份     通信设备   四川     0.00         0.00    0.00    196783.86   \n",
       "002931   锋龙股份     汽车配件   浙江     0.00         0.00    0.00     33967.37   \n",
       "000950  *ST建峰     农药化肥   重庆     0.00         5.99   17.28   1562395.13   \n",
       "000629  *ST钒钛       普钢   四川     0.00        47.67   85.90    999802.19   \n",
       "000511  *ST烯碳     矿物制品   辽宁     0.00        11.55   11.55    346274.91   \n",
       "603214    爱婴室       百货   上海     0.00         0.00    0.00     76961.15   \n",
       "600929   湖南盐业       食品   湖南     0.00         0.00    0.00    310491.63   \n",
       "600806  *ST昆机     机床制造   云南     0.00         3.90    5.31    193646.66   \n",
       "600432  *ST吉恩      小金属   吉林     0.00        16.04   16.04   1373541.75   \n",
       "\n",
       "        liquidAssets  fixedAssets   reserved    ...      bvps     pb  \\\n",
       "code                                            ...                    \n",
       "600249      99010.27    114079.50   85739.86    ...      3.52   1.83   \n",
       "000795     179590.45     60635.76  107166.20    ...      1.83   3.53   \n",
       "000151     188807.98      6801.99   44202.68    ...      3.29   4.07   \n",
       "002208    1148314.00      6756.07   29001.14    ...      5.10   2.67   \n",
       "300655      49096.92     16603.92   23198.64    ...      4.71   6.49   \n",
       "300523      96789.85     12613.92   40365.45    ...      6.04   8.73   \n",
       "603506          0.00         0.00       0.00    ...      4.35   9.98   \n",
       "300732     108083.01     20620.30   33782.26    ...     21.23   4.19   \n",
       "600405     174515.36     89155.57   55612.67    ...      2.35   2.95   \n",
       "300647      42642.17     25424.42   25124.00    ...      4.30   5.58   \n",
       "603712     277392.63     57633.35   63780.73    ...      2.29   9.00   \n",
       "300731      23502.03      1737.75    9434.82    ...      3.37   9.88   \n",
       "300688      40351.37       380.64   21506.17    ...      5.14  12.66   \n",
       "002922      58731.76         0.00       0.00    ...      5.00   5.28   \n",
       "300490      59965.38     11950.71   23825.85    ...      3.14   4.78   \n",
       "000672     265314.13    227190.45  -97110.06    ...      2.32   5.99   \n",
       "002853      96820.03     15414.80   48838.14    ...      5.26   6.08   \n",
       "002629      56109.20      6371.80    8860.48    ...      1.61   4.72   \n",
       "600801     789854.69   1591451.38  251120.30    ...      7.26   2.10   \n",
       "002596     268482.38     58270.35   64013.75    ...      2.34   5.07   \n",
       "603778     160503.88       993.25    2313.55    ...      1.92   3.93   \n",
       "601636     256674.52    804140.13  171494.67    ...      2.49   2.88   \n",
       "300737     171179.17     26359.14   58892.38    ...      3.15   5.39   \n",
       "300104    1410543.63    104074.28  820496.19    ...      3.13   2.11   \n",
       "000789     293580.13    405676.72   24090.26    ...      4.69   2.67   \n",
       "300727      25291.61     12968.00   10365.67    ...      4.76   7.33   \n",
       "002687      64897.92     51680.75   36338.87    ...      2.86   2.52   \n",
       "600802      66504.81    237439.88   21390.35    ...      1.80   4.25   \n",
       "603680     394765.72     58971.98   43780.80    ...      5.04   9.60   \n",
       "300643      34694.26      7265.92   13293.52    ...      2.03   6.40   \n",
       "...              ...          ...        ...    ...       ...    ...   \n",
       "603356      32024.01         0.00       0.00    ...      3.30   8.33   \n",
       "300298      71815.38     23339.95   33934.82    ...      3.39   6.33   \n",
       "603019     637031.06     84122.65  157540.70    ...      4.54  10.74   \n",
       "600789     194251.61    160819.11  109587.92    ...      3.25   3.21   \n",
       "300431     146162.69      4464.83   31970.78    ...      2.73  10.15   \n",
       "300561      64048.53      1469.56   33176.40    ...      8.03   5.14   \n",
       "300677      85487.75     63891.05   70667.90    ...     11.07   6.54   \n",
       "300066     108423.67     27638.00    6751.46    ...      1.46   3.23   \n",
       "300166     273063.00     22614.40  210379.02    ...      4.23   3.95   \n",
       "600093    1256731.63       375.16  403888.31    ...      5.77   2.75   \n",
       "300663      95675.75       207.80   37248.46    ...      4.38   6.53   \n",
       "300685      53230.90     12764.17   39687.85    ...      7.79  12.74   \n",
       "002879     140471.88     18471.20   76383.56    ...      9.92   3.57   \n",
       "601360     177465.42     50503.34   33821.80    ...      4.27  11.68   \n",
       "002912      77540.45         0.00       0.00    ...     17.08   7.22   \n",
       "300684      33648.35     24754.74   12281.78    ...      5.45  10.30   \n",
       "300542      58459.45      1190.14   22247.15    ...      6.22   5.59   \n",
       "300314      50522.89     22282.18   17553.43    ...      2.72   4.99   \n",
       "600588     671876.31    198737.13  221988.27    ...      3.50  10.30   \n",
       "601700     293546.72     40695.48  122509.51    ...      2.66   2.51   \n",
       "600634     366004.97      2749.05  193459.88    ...      5.15   2.75   \n",
       "300504          0.00         0.00       0.00    ...      0.00   0.00   \n",
       "002931      20617.76     10713.78    5462.35    ...      0.00   0.00   \n",
       "000950    1296451.63     48986.46  259775.59    ...      3.80   0.00   \n",
       "000629     379422.75    442935.09  552790.38    ...      0.48   0.00   \n",
       "000511     312833.03      2405.45   29655.31    ...      0.87   0.00   \n",
       "603214      61297.16      7078.72    2911.81    ...      0.00   0.00   \n",
       "600929      78859.31    139873.81   24281.50    ...      0.00   0.00   \n",
       "600806     121889.97     45542.53    1976.50    ...      0.41   0.00   \n",
       "600432     297409.28    768094.25  626871.94    ...      0.88   0.00   \n",
       "\n",
       "        timeToMarket        undp  perundp      rev  profit    gpr    npr  \\\n",
       "code                                                                       \n",
       "600249      20040130    11563.82     0.21    -5.29   23.70  20.24  -6.53   \n",
       "000795      19970808   -17884.21    -0.16    12.48  197.13  23.33   5.53   \n",
       "000151      20000906     9714.25     0.33    75.97  -13.01  13.48   4.15   \n",
       "002208      20080128    74377.09     2.32   -18.72  -66.96  26.76   1.64   \n",
       "300655      20170523     8065.47     0.91     0.00    0.00  27.95   5.99   \n",
       "300523      20160726    22047.11     1.53    14.30  -68.01  54.85   0.64   \n",
       "603506      20180201        0.00     0.00     0.00    0.00   0.00   8.71   \n",
       "300732      20171212    32869.48     4.57     0.00    0.00  47.88  22.71   \n",
       "600405      20040401    21281.20     0.38   -13.32 -208.35  32.16  -3.28   \n",
       "300647      20170503    13382.12     1.09     0.00    0.00  35.52  11.45   \n",
       "603712      20180226    20558.85     0.27     0.00    0.00  49.57   8.39   \n",
       "300731      20171208     5390.14     0.62     0.00    0.00  48.54  25.94   \n",
       "300688      20170810     6212.93     0.91     0.00    0.00  56.91  17.97   \n",
       "002922      20171229        0.00     0.00     0.00    0.00   0.00   7.03   \n",
       "300490      20151231    17474.20     0.76     1.29   -7.52  39.56   7.49   \n",
       "000672      19961218   180510.67     2.22    37.93  456.55  32.35  15.50   \n",
       "002853      20170310    23739.42     1.53     0.00    0.00  35.00  12.61   \n",
       "002629      20111103    12802.07     0.31  2306.35   70.91   2.03  -0.49   \n",
       "600801      19940103   629597.56     4.20    56.60  552.79  26.35   7.32   \n",
       "002596      20110707    57144.15     0.53    72.11  537.48  18.51   5.47   \n",
       "603778      20151231    39647.64     0.79    -2.90  -32.97  23.82  10.89   \n",
       "601636      20110812   237574.80     0.88    15.88   90.89  33.02  15.02   \n",
       "300737      20180125    29041.74     0.48     0.00    0.00  38.34  11.81   \n",
       "300104      20100812     -189.08     0.00   -63.67 -435.02 -16.19 -27.10   \n",
       "000789      19970923   186275.22     3.04    24.30   41.18  22.33   5.07   \n",
       "300727      20171127     8362.07     0.86     0.00    0.00  29.56  10.75   \n",
       "002687      20120713    19871.05     0.56     5.49    5.13  45.30   8.54   \n",
       "600802      19940103   -34063.92    -0.89    45.44   -9.33  10.55  -6.85   \n",
       "603680      20180227    83832.84     2.00     0.00    0.00  38.62  19.57   \n",
       "300643      20170505     6597.15     0.33     0.00    0.00  31.97  12.60   \n",
       "...              ...         ...      ...      ...     ...    ...    ...   \n",
       "603356      20180124        0.00     0.00     0.00    0.00   0.00  10.20   \n",
       "300298      20120319    46851.32     0.99    35.08   76.35  66.31  27.52   \n",
       "603019      20141106    64837.63     1.01    43.15    1.53  17.22   2.00   \n",
       "600789      19970226     5917.60     0.10     3.87  101.73  25.38   2.31   \n",
       "300431      20150324    34673.92     1.04    41.99    4.60  20.92   1.59   \n",
       "300561      20161117    20041.60     2.35    -8.43  -25.68  72.22  32.68   \n",
       "300677      20170721    29952.25     3.05    47.96   68.61  24.92   8.29   \n",
       "300066      20100326    31031.15     0.30   -13.71  -44.00  33.95  14.97   \n",
       "300166      20110125    97738.21     0.93    18.86   30.89  45.86  19.72   \n",
       "600093      19970626   121363.10     1.08   -12.56   37.96   7.29   6.33   \n",
       "300663      20170608     5791.01     0.43     0.00    0.00  34.29 -21.19   \n",
       "300685      20170802    13857.11     1.73     0.00    0.00  92.28  27.97   \n",
       "002879      20170707    41488.32     3.01     0.00    0.00  56.40  20.62   \n",
       "601360      20120116    80955.68     0.12    -9.63  -57.28  29.62   3.12   \n",
       "002912      20171121        0.00     0.00     0.00    0.00   0.00  31.45   \n",
       "300684      20171227    15325.42     1.76     0.00    0.00  34.84  10.49   \n",
       "300542      20160920    24093.03     2.64    41.06    8.85  22.48   2.78   \n",
       "300314      20120508    27732.10     0.96    21.95    6.12  52.74  23.62   \n",
       "600588      20010518    89537.00     0.61    24.41   26.69  64.97  -7.94   \n",
       "601700      20110118    41645.55     0.37   -21.90   -9.97  19.78   8.98   \n",
       "600634      19930304    39187.15     0.68   -72.23   62.32  81.69  10.87   \n",
       "300504             0        0.00     0.00    31.67   51.32   0.00   9.76   \n",
       "002931             0     9271.44     0.00    24.62   12.35  35.62  15.26   \n",
       "000950      19990916   193228.36     1.12     1.16  758.44   9.07   5.20   \n",
       "000629      19961115 -1146276.50    -1.33   -29.09  155.19  20.06  10.35   \n",
       "000511      19930518   -63425.48    -0.55    43.62  -55.46   0.22 -14.68   \n",
       "603214             0    25456.17     0.00    14.06   26.47  28.41   5.18   \n",
       "600929             0    71625.13     0.00     1.30   15.06  47.71   7.24   \n",
       "600806      19940103   -45091.93    -0.85    21.07  -23.37   3.60 -51.43   \n",
       "600432      20030905  -549617.19    -3.43     9.91  -56.24  15.12 -42.86   \n",
       "\n",
       "         holders  \n",
       "code              \n",
       "600249   62924.0  \n",
       "000795   96700.0  \n",
       "000151   37069.0  \n",
       "002208   34015.0  \n",
       "300655   10552.0  \n",
       "300523   11525.0  \n",
       "603506   18531.0  \n",
       "300732   16942.0  \n",
       "600405  120031.0  \n",
       "300647   16598.0  \n",
       "603712   88473.0  \n",
       "300731   45956.0  \n",
       "300688   15720.0  \n",
       "002922   65639.0  \n",
       "300490   17168.0  \n",
       "000672   70300.0  \n",
       "002853   28539.0  \n",
       "002629   31087.0  \n",
       "600801   65841.0  \n",
       "002596   21598.0  \n",
       "603778   35005.0  \n",
       "601636   63251.0  \n",
       "300737  281200.0  \n",
       "300104  185875.0  \n",
       "000789   41902.0  \n",
       "300727   50562.0  \n",
       "002687   27602.0  \n",
       "600802   47463.0  \n",
       "603680   40917.0  \n",
       "300643   22522.0  \n",
       "...          ...  \n",
       "603356   33471.0  \n",
       "300298   10839.0  \n",
       "603019   66635.0  \n",
       "600789  111040.0  \n",
       "300431   78925.0  \n",
       "300561   10943.0  \n",
       "300677   11500.0  \n",
       "300066   52798.0  \n",
       "300166   30680.0  \n",
       "600093   30574.0  \n",
       "300663   15286.0  \n",
       "300685   14639.0  \n",
       "002879   21318.0  \n",
       "601360   76200.0  \n",
       "002912   12930.0  \n",
       "300684   45590.0  \n",
       "300542   13816.0  \n",
       "300314   23140.0  \n",
       "600588   68068.0  \n",
       "601700   71668.0  \n",
       "600634   37100.0  \n",
       "300504       0.0  \n",
       "002931       0.0  \n",
       "000950   30624.0  \n",
       "000629  309056.0  \n",
       "000511  164822.0  \n",
       "603214       0.0  \n",
       "600929       0.0  \n",
       "600806   33099.0  \n",
       "600432   70654.0  \n",
       "\n",
       "[3505 rows x 22 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv('c:/stockdata/stocklist/20180315.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1521098123.3521397"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import time\n",
    "time.time()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'20180315'"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "time.strftime('%Y%m%d',time.localtime(time.time()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('username: 15010492066', '0,')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from jaqs.data import DataApi\n",
    "\n",
    "api = DataApi(addr=\"tcp://data.quantos.org:8910\")\n",
    "\n",
    "api.login(\"15010492066\", \"eyJhbGciOiJIUzI1NiJ9.eyJjcmVhdGVfdGltZSI6IjE1MTMwNTA0ODY3MTQiLCJpc3MiOiJhdXRoMCIsImlkIjoiMTUwMTA0OTIwNjYifQ.s_530n20Aelg7-8-1IorTgoa_yp6goImz20hhGIzMGU\") \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>isholiday</th>\n",
       "      <th>istradeday</th>\n",
       "      <th>isweekday</th>\n",
       "      <th>isweekend</th>\n",
       "      <th>trade_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>F</td>\n",
       "      <td>T</td>\n",
       "      <td>T</td>\n",
       "      <td>F</td>\n",
       "      <td>20180315</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  isholiday istradeday isweekday isweekend trade_date\n",
       "0         F          T         T         F   20180315"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df, msg = api.query(\n",
    "                view=\"jz.secTradeCal\", \n",
    "                fields=\"trade_date,istradeday, isweekday, isweekend, isholiday\", \n",
    "                filter=\"start_date=20180315&end_date=20180315\", \n",
    "                data_format='pandas')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'T'"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a = df['istradeday']\n",
    "a[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[Getting data:]############################################################"
     ]
    },
    {
     "ename": "NameError",
     "evalue": "name 'datestr' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-3-e3c8de288525>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[0;32m      3\u001b[0m \u001b[0mdf\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mts\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_today_all\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      4\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 5\u001b[1;33m \u001b[0mcsvPath\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mstockDailyDataPath\u001b[0m \u001b[1;33m+\u001b[0m \u001b[0mdatestr\u001b[0m \u001b[1;33m+\u001b[0m \u001b[1;34m\".csv\"\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      6\u001b[0m \u001b[0mdf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mto_csv\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mcsvPath\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      7\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mNameError\u001b[0m: name 'datestr' is not defined"
     ]
    }
   ],
   "source": [
    "stockDailyDataPath = \"c:/stockdata/stockdailydata/\"\n",
    "\n",
    "df = ts.get_today_all()\n",
    "\n",
    "csvPath = stockDailyDataPath + datestr + \".csv\"\n",
    "df.to_csv(csvPath)\n",
    "\n",
    "print(csvPath)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>changepercent</th>\n",
       "      <th>trade</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>settlement</th>\n",
       "      <th>volume</th>\n",
       "      <th>turnoverratio</th>\n",
       "      <th>amount</th>\n",
       "      <th>per</th>\n",
       "      <th>pb</th>\n",
       "      <th>mktcap</th>\n",
       "      <th>nmc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>603999</td>\n",
       "      <td>读者传媒</td>\n",
       "      <td>-1.626</td>\n",
       "      <td>7.26</td>\n",
       "      <td>7.37</td>\n",
       "      <td>7.37</td>\n",
       "      <td>7.21</td>\n",
       "      <td>7.38</td>\n",
       "      <td>1784994.0</td>\n",
       "      <td>0.77474</td>\n",
       "      <td>1.299070e+07</td>\n",
       "      <td>25.034</td>\n",
       "      <td>2.507</td>\n",
       "      <td>4.181760e+05</td>\n",
       "      <td>1.672704e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>603998</td>\n",
       "      <td>方盛制药</td>\n",
       "      <td>0.000</td>\n",
       "      <td>9.43</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>9.43</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>58.938</td>\n",
       "      <td>4.066</td>\n",
       "      <td>4.063731e+05</td>\n",
       "      <td>4.009605e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>603997</td>\n",
       "      <td>继峰股份</td>\n",
       "      <td>-1.550</td>\n",
       "      <td>11.43</td>\n",
       "      <td>11.56</td>\n",
       "      <td>11.56</td>\n",
       "      <td>11.35</td>\n",
       "      <td>11.61</td>\n",
       "      <td>3129670.0</td>\n",
       "      <td>0.49677</td>\n",
       "      <td>3.575766e+07</td>\n",
       "      <td>19.373</td>\n",
       "      <td>4.366</td>\n",
       "      <td>7.289130e+05</td>\n",
       "      <td>7.200900e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>603996</td>\n",
       "      <td>中新科技</td>\n",
       "      <td>0.232</td>\n",
       "      <td>17.28</td>\n",
       "      <td>17.09</td>\n",
       "      <td>17.44</td>\n",
       "      <td>17.02</td>\n",
       "      <td>17.24</td>\n",
       "      <td>3196827.0</td>\n",
       "      <td>3.09545</td>\n",
       "      <td>5.531282e+07</td>\n",
       "      <td>44.308</td>\n",
       "      <td>3.652</td>\n",
       "      <td>5.186592e+05</td>\n",
       "      <td>1.784592e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>603993</td>\n",
       "      <td>洛阳钼业</td>\n",
       "      <td>3.614</td>\n",
       "      <td>9.46</td>\n",
       "      <td>9.32</td>\n",
       "      <td>9.64</td>\n",
       "      <td>9.12</td>\n",
       "      <td>9.13</td>\n",
       "      <td>360724680.0</td>\n",
       "      <td>2.78472</td>\n",
       "      <td>3.393773e+09</td>\n",
       "      <td>157.667</td>\n",
       "      <td>5.481</td>\n",
       "      <td>2.043288e+07</td>\n",
       "      <td>1.225423e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>603991</td>\n",
       "      <td>至正股份</td>\n",
       "      <td>-3.898</td>\n",
       "      <td>22.93</td>\n",
       "      <td>23.72</td>\n",
       "      <td>23.79</td>\n",
       "      <td>22.21</td>\n",
       "      <td>23.86</td>\n",
       "      <td>925192.0</td>\n",
       "      <td>2.25223</td>\n",
       "      <td>2.121697e+07</td>\n",
       "      <td>34.224</td>\n",
       "      <td>3.850</td>\n",
       "      <td>1.709088e+05</td>\n",
       "      <td>9.419396e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>603990</td>\n",
       "      <td>麦迪科技</td>\n",
       "      <td>-2.957</td>\n",
       "      <td>34.79</td>\n",
       "      <td>35.85</td>\n",
       "      <td>35.85</td>\n",
       "      <td>34.75</td>\n",
       "      <td>35.85</td>\n",
       "      <td>224455.0</td>\n",
       "      <td>0.37240</td>\n",
       "      <td>7.902142e+06</td>\n",
       "      <td>46.387</td>\n",
       "      <td>6.863</td>\n",
       "      <td>2.815297e+05</td>\n",
       "      <td>2.096863e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>603989</td>\n",
       "      <td>艾华集团</td>\n",
       "      <td>-1.035</td>\n",
       "      <td>37.29</td>\n",
       "      <td>37.60</td>\n",
       "      <td>37.95</td>\n",
       "      <td>36.92</td>\n",
       "      <td>37.68</td>\n",
       "      <td>535000.0</td>\n",
       "      <td>0.63407</td>\n",
       "      <td>1.991867e+07</td>\n",
       "      <td>42.375</td>\n",
       "      <td>6.336</td>\n",
       "      <td>1.118700e+06</td>\n",
       "      <td>3.146344e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>603988</td>\n",
       "      <td>中电电机</td>\n",
       "      <td>-5.517</td>\n",
       "      <td>31.34</td>\n",
       "      <td>32.69</td>\n",
       "      <td>32.82</td>\n",
       "      <td>30.36</td>\n",
       "      <td>33.17</td>\n",
       "      <td>2614902.0</td>\n",
       "      <td>2.17909</td>\n",
       "      <td>8.252070e+07</td>\n",
       "      <td>104.467</td>\n",
       "      <td>3.809</td>\n",
       "      <td>3.760800e+05</td>\n",
       "      <td>3.760800e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>603987</td>\n",
       "      <td>康德莱</td>\n",
       "      <td>-1.817</td>\n",
       "      <td>11.35</td>\n",
       "      <td>11.55</td>\n",
       "      <td>11.64</td>\n",
       "      <td>11.25</td>\n",
       "      <td>11.56</td>\n",
       "      <td>1612548.0</td>\n",
       "      <td>0.84839</td>\n",
       "      <td>1.840273e+07</td>\n",
       "      <td>18.306</td>\n",
       "      <td>2.989</td>\n",
       "      <td>3.580187e+05</td>\n",
       "      <td>2.157311e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>603986</td>\n",
       "      <td>兆易创新</td>\n",
       "      <td>3.612</td>\n",
       "      <td>199.66</td>\n",
       "      <td>191.30</td>\n",
       "      <td>199.98</td>\n",
       "      <td>191.10</td>\n",
       "      <td>192.70</td>\n",
       "      <td>5645599.0</td>\n",
       "      <td>3.83154</td>\n",
       "      <td>1.112856e+09</td>\n",
       "      <td>94.308</td>\n",
       "      <td>25.238</td>\n",
       "      <td>4.046704e+06</td>\n",
       "      <td>2.941897e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>603985</td>\n",
       "      <td>恒润股份</td>\n",
       "      <td>-3.437</td>\n",
       "      <td>31.47</td>\n",
       "      <td>32.59</td>\n",
       "      <td>32.59</td>\n",
       "      <td>31.17</td>\n",
       "      <td>32.59</td>\n",
       "      <td>601000.0</td>\n",
       "      <td>3.00500</td>\n",
       "      <td>1.905178e+07</td>\n",
       "      <td>19.935</td>\n",
       "      <td>2.580</td>\n",
       "      <td>2.517600e+05</td>\n",
       "      <td>6.294000e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>603980</td>\n",
       "      <td>吉华集团</td>\n",
       "      <td>-1.511</td>\n",
       "      <td>19.56</td>\n",
       "      <td>19.76</td>\n",
       "      <td>20.01</td>\n",
       "      <td>19.41</td>\n",
       "      <td>19.86</td>\n",
       "      <td>3043696.0</td>\n",
       "      <td>3.04370</td>\n",
       "      <td>5.994944e+07</td>\n",
       "      <td>20.460</td>\n",
       "      <td>2.523</td>\n",
       "      <td>9.780000e+05</td>\n",
       "      <td>1.956000e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>603979</td>\n",
       "      <td>金诚信</td>\n",
       "      <td>-1.726</td>\n",
       "      <td>9.68</td>\n",
       "      <td>9.84</td>\n",
       "      <td>9.87</td>\n",
       "      <td>9.60</td>\n",
       "      <td>9.85</td>\n",
       "      <td>2132336.0</td>\n",
       "      <td>0.87693</td>\n",
       "      <td>2.069221e+07</td>\n",
       "      <td>23.048</td>\n",
       "      <td>1.490</td>\n",
       "      <td>5.662800e+05</td>\n",
       "      <td>2.353792e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>603978</td>\n",
       "      <td>深圳新星</td>\n",
       "      <td>-3.464</td>\n",
       "      <td>75.53</td>\n",
       "      <td>79.00</td>\n",
       "      <td>79.50</td>\n",
       "      <td>74.13</td>\n",
       "      <td>78.24</td>\n",
       "      <td>1058405.0</td>\n",
       "      <td>5.29203</td>\n",
       "      <td>8.038080e+07</td>\n",
       "      <td>34.176</td>\n",
       "      <td>4.660</td>\n",
       "      <td>6.042400e+05</td>\n",
       "      <td>1.510600e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>603977</td>\n",
       "      <td>国泰集团</td>\n",
       "      <td>-1.664</td>\n",
       "      <td>13.59</td>\n",
       "      <td>13.61</td>\n",
       "      <td>13.79</td>\n",
       "      <td>13.35</td>\n",
       "      <td>13.82</td>\n",
       "      <td>2758112.0</td>\n",
       "      <td>2.19455</td>\n",
       "      <td>3.743481e+07</td>\n",
       "      <td>43.839</td>\n",
       "      <td>3.171</td>\n",
       "      <td>3.004477e+05</td>\n",
       "      <td>1.707991e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>603976</td>\n",
       "      <td>正川股份</td>\n",
       "      <td>-4.663</td>\n",
       "      <td>22.49</td>\n",
       "      <td>23.45</td>\n",
       "      <td>23.45</td>\n",
       "      <td>21.71</td>\n",
       "      <td>23.59</td>\n",
       "      <td>1438137.0</td>\n",
       "      <td>5.32643</td>\n",
       "      <td>3.261158e+07</td>\n",
       "      <td>25.851</td>\n",
       "      <td>2.591</td>\n",
       "      <td>2.428920e+05</td>\n",
       "      <td>6.072300e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>603970</td>\n",
       "      <td>中农立华</td>\n",
       "      <td>-5.982</td>\n",
       "      <td>23.26</td>\n",
       "      <td>24.27</td>\n",
       "      <td>24.46</td>\n",
       "      <td>22.72</td>\n",
       "      <td>24.74</td>\n",
       "      <td>4852872.0</td>\n",
       "      <td>14.55859</td>\n",
       "      <td>1.141641e+08</td>\n",
       "      <td>28.463</td>\n",
       "      <td>6.161</td>\n",
       "      <td>3.101335e+05</td>\n",
       "      <td>7.753349e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>603969</td>\n",
       "      <td>银龙股份</td>\n",
       "      <td>-1.345</td>\n",
       "      <td>13.20</td>\n",
       "      <td>13.20</td>\n",
       "      <td>13.45</td>\n",
       "      <td>12.92</td>\n",
       "      <td>13.38</td>\n",
       "      <td>5486201.0</td>\n",
       "      <td>1.37155</td>\n",
       "      <td>7.221390e+07</td>\n",
       "      <td>36.667</td>\n",
       "      <td>3.301</td>\n",
       "      <td>5.280000e+05</td>\n",
       "      <td>5.280000e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>603968</td>\n",
       "      <td>醋化股份</td>\n",
       "      <td>-0.207</td>\n",
       "      <td>19.31</td>\n",
       "      <td>19.28</td>\n",
       "      <td>19.37</td>\n",
       "      <td>19.03</td>\n",
       "      <td>19.35</td>\n",
       "      <td>525710.0</td>\n",
       "      <td>0.38485</td>\n",
       "      <td>1.007653e+07</td>\n",
       "      <td>26.819</td>\n",
       "      <td>3.071</td>\n",
       "      <td>3.948509e+05</td>\n",
       "      <td>2.637746e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>603966</td>\n",
       "      <td>法兰泰克</td>\n",
       "      <td>-4.289</td>\n",
       "      <td>13.39</td>\n",
       "      <td>13.97</td>\n",
       "      <td>13.97</td>\n",
       "      <td>13.15</td>\n",
       "      <td>13.99</td>\n",
       "      <td>1577950.0</td>\n",
       "      <td>2.20600</td>\n",
       "      <td>2.123359e+07</td>\n",
       "      <td>28.489</td>\n",
       "      <td>2.676</td>\n",
       "      <td>2.142400e+05</td>\n",
       "      <td>9.577878e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>603963</td>\n",
       "      <td>大理药业</td>\n",
       "      <td>-5.543</td>\n",
       "      <td>28.29</td>\n",
       "      <td>29.39</td>\n",
       "      <td>29.72</td>\n",
       "      <td>26.98</td>\n",
       "      <td>29.95</td>\n",
       "      <td>3249959.0</td>\n",
       "      <td>12.99984</td>\n",
       "      <td>9.247120e+07</td>\n",
       "      <td>34.084</td>\n",
       "      <td>6.177</td>\n",
       "      <td>2.829000e+05</td>\n",
       "      <td>7.072500e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>603960</td>\n",
       "      <td>克来机电</td>\n",
       "      <td>-5.825</td>\n",
       "      <td>27.97</td>\n",
       "      <td>29.50</td>\n",
       "      <td>30.52</td>\n",
       "      <td>26.89</td>\n",
       "      <td>29.70</td>\n",
       "      <td>1479845.0</td>\n",
       "      <td>3.71329</td>\n",
       "      <td>4.277741e+07</td>\n",
       "      <td>46.617</td>\n",
       "      <td>6.996</td>\n",
       "      <td>2.908880e+05</td>\n",
       "      <td>1.114678e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>603959</td>\n",
       "      <td>百利科技</td>\n",
       "      <td>-0.444</td>\n",
       "      <td>35.88</td>\n",
       "      <td>35.95</td>\n",
       "      <td>36.66</td>\n",
       "      <td>35.51</td>\n",
       "      <td>36.04</td>\n",
       "      <td>1119961.0</td>\n",
       "      <td>1.05946</td>\n",
       "      <td>4.035996e+07</td>\n",
       "      <td>67.698</td>\n",
       "      <td>8.849</td>\n",
       "      <td>8.037120e+05</td>\n",
       "      <td>3.792903e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>603958</td>\n",
       "      <td>哈森股份</td>\n",
       "      <td>-4.475</td>\n",
       "      <td>11.10</td>\n",
       "      <td>11.64</td>\n",
       "      <td>11.64</td>\n",
       "      <td>10.91</td>\n",
       "      <td>11.62</td>\n",
       "      <td>2528389.0</td>\n",
       "      <td>3.83095</td>\n",
       "      <td>2.832248e+07</td>\n",
       "      <td>26.241</td>\n",
       "      <td>2.126</td>\n",
       "      <td>2.412696e+05</td>\n",
       "      <td>7.325889e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>603955</td>\n",
       "      <td>大千生态</td>\n",
       "      <td>0.000</td>\n",
       "      <td>35.88</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>35.88</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>33.608</td>\n",
       "      <td>3.009</td>\n",
       "      <td>3.121560e+05</td>\n",
       "      <td>1.968438e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>603939</td>\n",
       "      <td>益丰药房</td>\n",
       "      <td>2.093</td>\n",
       "      <td>51.70</td>\n",
       "      <td>50.56</td>\n",
       "      <td>53.04</td>\n",
       "      <td>50.21</td>\n",
       "      <td>50.64</td>\n",
       "      <td>1297653.0</td>\n",
       "      <td>0.35778</td>\n",
       "      <td>6.750314e+07</td>\n",
       "      <td>77.979</td>\n",
       "      <td>6.100</td>\n",
       "      <td>1.875131e+06</td>\n",
       "      <td>1.875131e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>603938</td>\n",
       "      <td>三孚股份</td>\n",
       "      <td>-2.293</td>\n",
       "      <td>33.23</td>\n",
       "      <td>34.06</td>\n",
       "      <td>34.47</td>\n",
       "      <td>31.73</td>\n",
       "      <td>34.01</td>\n",
       "      <td>3584083.0</td>\n",
       "      <td>9.54315</td>\n",
       "      <td>1.186333e+08</td>\n",
       "      <td>46.153</td>\n",
       "      <td>5.364</td>\n",
       "      <td>4.990036e+05</td>\n",
       "      <td>1.248006e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>603937</td>\n",
       "      <td>丽岛新材</td>\n",
       "      <td>-6.747</td>\n",
       "      <td>20.04</td>\n",
       "      <td>21.05</td>\n",
       "      <td>21.29</td>\n",
       "      <td>19.46</td>\n",
       "      <td>21.49</td>\n",
       "      <td>8342710.0</td>\n",
       "      <td>15.97608</td>\n",
       "      <td>1.690305e+08</td>\n",
       "      <td>35.786</td>\n",
       "      <td>4.078</td>\n",
       "      <td>4.185955e+05</td>\n",
       "      <td>1.046489e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>603936</td>\n",
       "      <td>博敏电子</td>\n",
       "      <td>-3.787</td>\n",
       "      <td>20.58</td>\n",
       "      <td>21.46</td>\n",
       "      <td>21.56</td>\n",
       "      <td>20.37</td>\n",
       "      <td>21.39</td>\n",
       "      <td>1940645.0</td>\n",
       "      <td>3.45926</td>\n",
       "      <td>4.049307e+07</td>\n",
       "      <td>64.514</td>\n",
       "      <td>3.512</td>\n",
       "      <td>3.444063e+05</td>\n",
       "      <td>1.154538e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3474</th>\n",
       "      <td>600539</td>\n",
       "      <td>狮头股份</td>\n",
       "      <td>0.000</td>\n",
       "      <td>16.80</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>16.80</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>-336.000</td>\n",
       "      <td>8.143</td>\n",
       "      <td>3.864000e+05</td>\n",
       "      <td>3.864000e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3475</th>\n",
       "      <td>600444</td>\n",
       "      <td>国机通用</td>\n",
       "      <td>1.014</td>\n",
       "      <td>13.94</td>\n",
       "      <td>13.76</td>\n",
       "      <td>14.19</td>\n",
       "      <td>13.66</td>\n",
       "      <td>13.80</td>\n",
       "      <td>825618.0</td>\n",
       "      <td>0.78630</td>\n",
       "      <td>1.148406e+07</td>\n",
       "      <td>132.762</td>\n",
       "      <td>5.537</td>\n",
       "      <td>2.041122e+05</td>\n",
       "      <td>1.463700e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3476</th>\n",
       "      <td>600432</td>\n",
       "      <td>*ST吉恩</td>\n",
       "      <td>0.000</td>\n",
       "      <td>6.74</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.74</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>-4.956</td>\n",
       "      <td>7.663</td>\n",
       "      <td>1.080910e+06</td>\n",
       "      <td>1.080910e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3477</th>\n",
       "      <td>600425</td>\n",
       "      <td>*ST青松</td>\n",
       "      <td>-0.546</td>\n",
       "      <td>3.64</td>\n",
       "      <td>3.66</td>\n",
       "      <td>3.69</td>\n",
       "      <td>3.60</td>\n",
       "      <td>3.66</td>\n",
       "      <td>7020806.0</td>\n",
       "      <td>0.50920</td>\n",
       "      <td>2.558911e+07</td>\n",
       "      <td>-8.667</td>\n",
       "      <td>1.255</td>\n",
       "      <td>5.018796e+05</td>\n",
       "      <td>5.018796e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3478</th>\n",
       "      <td>600423</td>\n",
       "      <td>*ST柳化</td>\n",
       "      <td>0.000</td>\n",
       "      <td>4.83</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.83</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>32.200</td>\n",
       "      <td>49.948</td>\n",
       "      <td>1.928848e+05</td>\n",
       "      <td>1.928848e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3479</th>\n",
       "      <td>600421</td>\n",
       "      <td>ST仰帆</td>\n",
       "      <td>-1.358</td>\n",
       "      <td>7.99</td>\n",
       "      <td>8.14</td>\n",
       "      <td>8.15</td>\n",
       "      <td>7.93</td>\n",
       "      <td>8.10</td>\n",
       "      <td>456142.0</td>\n",
       "      <td>0.23320</td>\n",
       "      <td>3.664883e+06</td>\n",
       "      <td>399.500</td>\n",
       "      <td>238.507</td>\n",
       "      <td>1.562844e+05</td>\n",
       "      <td>1.562844e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3480</th>\n",
       "      <td>600408</td>\n",
       "      <td>安泰集团</td>\n",
       "      <td>-0.781</td>\n",
       "      <td>2.54</td>\n",
       "      <td>2.56</td>\n",
       "      <td>2.57</td>\n",
       "      <td>2.51</td>\n",
       "      <td>2.56</td>\n",
       "      <td>7433530.0</td>\n",
       "      <td>0.73833</td>\n",
       "      <td>1.885118e+07</td>\n",
       "      <td>-4.379</td>\n",
       "      <td>2.626</td>\n",
       "      <td>2.557272e+05</td>\n",
       "      <td>2.557272e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3481</th>\n",
       "      <td>600403</td>\n",
       "      <td>*ST大有</td>\n",
       "      <td>-0.881</td>\n",
       "      <td>4.50</td>\n",
       "      <td>4.53</td>\n",
       "      <td>4.54</td>\n",
       "      <td>4.48</td>\n",
       "      <td>4.54</td>\n",
       "      <td>1375514.0</td>\n",
       "      <td>0.05753</td>\n",
       "      <td>6.199642e+06</td>\n",
       "      <td>-5.488</td>\n",
       "      <td>1.536</td>\n",
       "      <td>1.075866e+06</td>\n",
       "      <td>1.075866e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3482</th>\n",
       "      <td>600401</td>\n",
       "      <td>*ST海润</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>-3.486</td>\n",
       "      <td>1.432</td>\n",
       "      <td>4.110694e+05</td>\n",
       "      <td>4.110694e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3483</th>\n",
       "      <td>600311</td>\n",
       "      <td>荣华实业</td>\n",
       "      <td>-2.450</td>\n",
       "      <td>4.38</td>\n",
       "      <td>4.49</td>\n",
       "      <td>4.49</td>\n",
       "      <td>4.33</td>\n",
       "      <td>4.49</td>\n",
       "      <td>8734691.0</td>\n",
       "      <td>1.31230</td>\n",
       "      <td>3.835258e+07</td>\n",
       "      <td>-44.877</td>\n",
       "      <td>3.505</td>\n",
       "      <td>2.915328e+05</td>\n",
       "      <td>2.915328e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3484</th>\n",
       "      <td>600301</td>\n",
       "      <td>ST南化</td>\n",
       "      <td>-1.207</td>\n",
       "      <td>6.55</td>\n",
       "      <td>6.61</td>\n",
       "      <td>6.74</td>\n",
       "      <td>6.50</td>\n",
       "      <td>6.63</td>\n",
       "      <td>1079694.0</td>\n",
       "      <td>0.45915</td>\n",
       "      <td>7.087585e+06</td>\n",
       "      <td>-47.429</td>\n",
       "      <td>6.371</td>\n",
       "      <td>1.540220e+05</td>\n",
       "      <td>1.540220e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3485</th>\n",
       "      <td>600289</td>\n",
       "      <td>ST信通</td>\n",
       "      <td>-3.275</td>\n",
       "      <td>3.84</td>\n",
       "      <td>3.96</td>\n",
       "      <td>3.99</td>\n",
       "      <td>3.77</td>\n",
       "      <td>3.97</td>\n",
       "      <td>16136488.0</td>\n",
       "      <td>2.85136</td>\n",
       "      <td>6.225101e+07</td>\n",
       "      <td>17.220</td>\n",
       "      <td>0.775</td>\n",
       "      <td>2.423240e+05</td>\n",
       "      <td>2.173143e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3486</th>\n",
       "      <td>600275</td>\n",
       "      <td>*ST昌鱼</td>\n",
       "      <td>-3.012</td>\n",
       "      <td>4.83</td>\n",
       "      <td>4.93</td>\n",
       "      <td>5.00</td>\n",
       "      <td>4.81</td>\n",
       "      <td>4.98</td>\n",
       "      <td>2714101.0</td>\n",
       "      <td>0.53339</td>\n",
       "      <td>1.327585e+07</td>\n",
       "      <td>-59.703</td>\n",
       "      <td>21.410</td>\n",
       "      <td>2.457684e+05</td>\n",
       "      <td>2.457684e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3487</th>\n",
       "      <td>600265</td>\n",
       "      <td>ST景谷</td>\n",
       "      <td>-2.407</td>\n",
       "      <td>17.84</td>\n",
       "      <td>17.40</td>\n",
       "      <td>18.19</td>\n",
       "      <td>17.40</td>\n",
       "      <td>18.28</td>\n",
       "      <td>209085.0</td>\n",
       "      <td>0.16108</td>\n",
       "      <td>3.724200e+06</td>\n",
       "      <td>68.615</td>\n",
       "      <td>59.073</td>\n",
       "      <td>2.315632e+05</td>\n",
       "      <td>2.315632e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3488</th>\n",
       "      <td>600247</td>\n",
       "      <td>ST成城</td>\n",
       "      <td>4.969</td>\n",
       "      <td>8.45</td>\n",
       "      <td>8.26</td>\n",
       "      <td>8.45</td>\n",
       "      <td>8.12</td>\n",
       "      <td>8.05</td>\n",
       "      <td>2183801.0</td>\n",
       "      <td>0.64909</td>\n",
       "      <td>1.836348e+07</td>\n",
       "      <td>-13.255</td>\n",
       "      <td>-9.674</td>\n",
       "      <td>2.842932e+05</td>\n",
       "      <td>2.842932e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3489</th>\n",
       "      <td>600242</td>\n",
       "      <td>中昌数据</td>\n",
       "      <td>-1.027</td>\n",
       "      <td>15.42</td>\n",
       "      <td>15.50</td>\n",
       "      <td>15.63</td>\n",
       "      <td>15.19</td>\n",
       "      <td>15.58</td>\n",
       "      <td>2106800.0</td>\n",
       "      <td>0.73834</td>\n",
       "      <td>3.249153e+07</td>\n",
       "      <td>154.200</td>\n",
       "      <td>3.609</td>\n",
       "      <td>7.041776e+05</td>\n",
       "      <td>4.399959e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3490</th>\n",
       "      <td>600234</td>\n",
       "      <td>ST山水</td>\n",
       "      <td>-1.374</td>\n",
       "      <td>12.92</td>\n",
       "      <td>12.90</td>\n",
       "      <td>13.39</td>\n",
       "      <td>12.88</td>\n",
       "      <td>13.10</td>\n",
       "      <td>272300.0</td>\n",
       "      <td>0.13451</td>\n",
       "      <td>3.574928e+06</td>\n",
       "      <td>184.571</td>\n",
       "      <td>30.322</td>\n",
       "      <td>2.615601e+05</td>\n",
       "      <td>2.615601e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3491</th>\n",
       "      <td>600228</td>\n",
       "      <td>*ST昌九</td>\n",
       "      <td>-3.429</td>\n",
       "      <td>11.83</td>\n",
       "      <td>12.60</td>\n",
       "      <td>12.60</td>\n",
       "      <td>11.64</td>\n",
       "      <td>12.25</td>\n",
       "      <td>3409225.0</td>\n",
       "      <td>1.41274</td>\n",
       "      <td>4.103130e+07</td>\n",
       "      <td>-78.867</td>\n",
       "      <td>492.917</td>\n",
       "      <td>2.854816e+05</td>\n",
       "      <td>2.854816e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3492</th>\n",
       "      <td>600225</td>\n",
       "      <td>*ST松江</td>\n",
       "      <td>0.676</td>\n",
       "      <td>4.47</td>\n",
       "      <td>4.42</td>\n",
       "      <td>4.47</td>\n",
       "      <td>4.42</td>\n",
       "      <td>4.44</td>\n",
       "      <td>2633430.0</td>\n",
       "      <td>0.28245</td>\n",
       "      <td>1.169936e+07</td>\n",
       "      <td>-9.122</td>\n",
       "      <td>2.290</td>\n",
       "      <td>4.181652e+05</td>\n",
       "      <td>4.167547e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3493</th>\n",
       "      <td>600217</td>\n",
       "      <td>中再资环</td>\n",
       "      <td>-1.536</td>\n",
       "      <td>6.41</td>\n",
       "      <td>6.47</td>\n",
       "      <td>6.49</td>\n",
       "      <td>6.25</td>\n",
       "      <td>6.51</td>\n",
       "      <td>7853630.0</td>\n",
       "      <td>1.09048</td>\n",
       "      <td>4.996523e+07</td>\n",
       "      <td>57.489</td>\n",
       "      <td>5.621</td>\n",
       "      <td>8.901309e+05</td>\n",
       "      <td>4.616467e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3494</th>\n",
       "      <td>600163</td>\n",
       "      <td>中闽能源</td>\n",
       "      <td>-0.726</td>\n",
       "      <td>4.10</td>\n",
       "      <td>4.14</td>\n",
       "      <td>4.14</td>\n",
       "      <td>4.06</td>\n",
       "      <td>4.13</td>\n",
       "      <td>3765147.0</td>\n",
       "      <td>0.49961</td>\n",
       "      <td>1.537594e+07</td>\n",
       "      <td>38.679</td>\n",
       "      <td>2.461</td>\n",
       "      <td>4.097807e+05</td>\n",
       "      <td>3.089858e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3495</th>\n",
       "      <td>600149</td>\n",
       "      <td>*ST坊展</td>\n",
       "      <td>-2.436</td>\n",
       "      <td>8.41</td>\n",
       "      <td>8.60</td>\n",
       "      <td>8.63</td>\n",
       "      <td>8.24</td>\n",
       "      <td>8.62</td>\n",
       "      <td>4541551.0</td>\n",
       "      <td>1.19464</td>\n",
       "      <td>3.837143e+07</td>\n",
       "      <td>-128.988</td>\n",
       "      <td>17.916</td>\n",
       "      <td>3.197146e+05</td>\n",
       "      <td>3.197146e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3496</th>\n",
       "      <td>600145</td>\n",
       "      <td>*ST新亿</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.87</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.87</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>-935.000</td>\n",
       "      <td>4.503</td>\n",
       "      <td>2.788358e+05</td>\n",
       "      <td>2.788358e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3497</th>\n",
       "      <td>600121</td>\n",
       "      <td>*ST郑煤</td>\n",
       "      <td>-1.071</td>\n",
       "      <td>5.54</td>\n",
       "      <td>5.58</td>\n",
       "      <td>5.61</td>\n",
       "      <td>5.46</td>\n",
       "      <td>5.60</td>\n",
       "      <td>3940538.0</td>\n",
       "      <td>0.38810</td>\n",
       "      <td>2.188287e+07</td>\n",
       "      <td>-8.931</td>\n",
       "      <td>1.653</td>\n",
       "      <td>5.625002e+05</td>\n",
       "      <td>5.625002e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3498</th>\n",
       "      <td>600112</td>\n",
       "      <td>*ST天成</td>\n",
       "      <td>-4.357</td>\n",
       "      <td>4.61</td>\n",
       "      <td>4.78</td>\n",
       "      <td>4.84</td>\n",
       "      <td>4.58</td>\n",
       "      <td>4.82</td>\n",
       "      <td>18789104.0</td>\n",
       "      <td>3.68989</td>\n",
       "      <td>8.731834e+07</td>\n",
       "      <td>-23.726</td>\n",
       "      <td>1.984</td>\n",
       "      <td>2.347434e+05</td>\n",
       "      <td>2.347434e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3499</th>\n",
       "      <td>600091</td>\n",
       "      <td>ST明科</td>\n",
       "      <td>-2.335</td>\n",
       "      <td>4.60</td>\n",
       "      <td>4.68</td>\n",
       "      <td>4.70</td>\n",
       "      <td>4.54</td>\n",
       "      <td>4.71</td>\n",
       "      <td>2350250.0</td>\n",
       "      <td>0.69839</td>\n",
       "      <td>1.082024e+07</td>\n",
       "      <td>153.333</td>\n",
       "      <td>2.229</td>\n",
       "      <td>2.012098e+05</td>\n",
       "      <td>1.548020e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3500</th>\n",
       "      <td>600087</td>\n",
       "      <td>退市长油</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3501</th>\n",
       "      <td>600074</td>\n",
       "      <td>ST保千里</td>\n",
       "      <td>-2.183</td>\n",
       "      <td>2.24</td>\n",
       "      <td>2.27</td>\n",
       "      <td>2.28</td>\n",
       "      <td>2.21</td>\n",
       "      <td>2.29</td>\n",
       "      <td>45891285.0</td>\n",
       "      <td>4.47260</td>\n",
       "      <td>1.029404e+08</td>\n",
       "      <td>6.400</td>\n",
       "      <td>1.137</td>\n",
       "      <td>5.460865e+05</td>\n",
       "      <td>2.298359e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3502</th>\n",
       "      <td>600071</td>\n",
       "      <td>凤凰光学</td>\n",
       "      <td>1.930</td>\n",
       "      <td>17.43</td>\n",
       "      <td>17.22</td>\n",
       "      <td>17.79</td>\n",
       "      <td>17.02</td>\n",
       "      <td>17.10</td>\n",
       "      <td>2073395.0</td>\n",
       "      <td>0.87311</td>\n",
       "      <td>3.612250e+07</td>\n",
       "      <td>124.500</td>\n",
       "      <td>9.771</td>\n",
       "      <td>4.139145e+05</td>\n",
       "      <td>4.139145e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3503</th>\n",
       "      <td>600069</td>\n",
       "      <td>银鸽投资</td>\n",
       "      <td>0.000</td>\n",
       "      <td>7.42</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>7.42</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>-23.188</td>\n",
       "      <td>4.549</td>\n",
       "      <td>9.268344e+05</td>\n",
       "      <td>6.124276e+05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3504 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        code   name  changepercent   trade    open    high     low  \\\n",
       "0     603999   读者传媒         -1.626    7.26    7.37    7.37    7.21   \n",
       "1     603998   方盛制药          0.000    9.43    0.00    0.00    0.00   \n",
       "2     603997   继峰股份         -1.550   11.43   11.56   11.56   11.35   \n",
       "3     603996   中新科技          0.232   17.28   17.09   17.44   17.02   \n",
       "4     603993   洛阳钼业          3.614    9.46    9.32    9.64    9.12   \n",
       "5     603991   至正股份         -3.898   22.93   23.72   23.79   22.21   \n",
       "6     603990   麦迪科技         -2.957   34.79   35.85   35.85   34.75   \n",
       "7     603989   艾华集团         -1.035   37.29   37.60   37.95   36.92   \n",
       "8     603988   中电电机         -5.517   31.34   32.69   32.82   30.36   \n",
       "9     603987    康德莱         -1.817   11.35   11.55   11.64   11.25   \n",
       "10    603986   兆易创新          3.612  199.66  191.30  199.98  191.10   \n",
       "11    603985   恒润股份         -3.437   31.47   32.59   32.59   31.17   \n",
       "12    603980   吉华集团         -1.511   19.56   19.76   20.01   19.41   \n",
       "13    603979    金诚信         -1.726    9.68    9.84    9.87    9.60   \n",
       "14    603978   深圳新星         -3.464   75.53   79.00   79.50   74.13   \n",
       "15    603977   国泰集团         -1.664   13.59   13.61   13.79   13.35   \n",
       "16    603976   正川股份         -4.663   22.49   23.45   23.45   21.71   \n",
       "17    603970   中农立华         -5.982   23.26   24.27   24.46   22.72   \n",
       "18    603969   银龙股份         -1.345   13.20   13.20   13.45   12.92   \n",
       "19    603968   醋化股份         -0.207   19.31   19.28   19.37   19.03   \n",
       "20    603966   法兰泰克         -4.289   13.39   13.97   13.97   13.15   \n",
       "21    603963   大理药业         -5.543   28.29   29.39   29.72   26.98   \n",
       "22    603960   克来机电         -5.825   27.97   29.50   30.52   26.89   \n",
       "23    603959   百利科技         -0.444   35.88   35.95   36.66   35.51   \n",
       "24    603958   哈森股份         -4.475   11.10   11.64   11.64   10.91   \n",
       "25    603955   大千生态          0.000   35.88    0.00    0.00    0.00   \n",
       "26    603939   益丰药房          2.093   51.70   50.56   53.04   50.21   \n",
       "27    603938   三孚股份         -2.293   33.23   34.06   34.47   31.73   \n",
       "28    603937   丽岛新材         -6.747   20.04   21.05   21.29   19.46   \n",
       "29    603936   博敏电子         -3.787   20.58   21.46   21.56   20.37   \n",
       "...      ...    ...            ...     ...     ...     ...     ...   \n",
       "3474  600539   狮头股份          0.000   16.80    0.00    0.00    0.00   \n",
       "3475  600444   国机通用          1.014   13.94   13.76   14.19   13.66   \n",
       "3476  600432  *ST吉恩          0.000    6.74    0.00    0.00    0.00   \n",
       "3477  600425  *ST青松         -0.546    3.64    3.66    3.69    3.60   \n",
       "3478  600423  *ST柳化          0.000    4.83    0.00    0.00    0.00   \n",
       "3479  600421   ST仰帆         -1.358    7.99    8.14    8.15    7.93   \n",
       "3480  600408   安泰集团         -0.781    2.54    2.56    2.57    2.51   \n",
       "3481  600403  *ST大有         -0.881    4.50    4.53    4.54    4.48   \n",
       "3482  600401  *ST海润          0.000    0.87    0.00    0.00    0.00   \n",
       "3483  600311   荣华实业         -2.450    4.38    4.49    4.49    4.33   \n",
       "3484  600301   ST南化         -1.207    6.55    6.61    6.74    6.50   \n",
       "3485  600289   ST信通         -3.275    3.84    3.96    3.99    3.77   \n",
       "3486  600275  *ST昌鱼         -3.012    4.83    4.93    5.00    4.81   \n",
       "3487  600265   ST景谷         -2.407   17.84   17.40   18.19   17.40   \n",
       "3488  600247   ST成城          4.969    8.45    8.26    8.45    8.12   \n",
       "3489  600242   中昌数据         -1.027   15.42   15.50   15.63   15.19   \n",
       "3490  600234   ST山水         -1.374   12.92   12.90   13.39   12.88   \n",
       "3491  600228  *ST昌九         -3.429   11.83   12.60   12.60   11.64   \n",
       "3492  600225  *ST松江          0.676    4.47    4.42    4.47    4.42   \n",
       "3493  600217   中再资环         -1.536    6.41    6.47    6.49    6.25   \n",
       "3494  600163   中闽能源         -0.726    4.10    4.14    4.14    4.06   \n",
       "3495  600149  *ST坊展         -2.436    8.41    8.60    8.63    8.24   \n",
       "3496  600145  *ST新亿          0.000    1.87    0.00    0.00    0.00   \n",
       "3497  600121  *ST郑煤         -1.071    5.54    5.58    5.61    5.46   \n",
       "3498  600112  *ST天成         -4.357    4.61    4.78    4.84    4.58   \n",
       "3499  600091   ST明科         -2.335    4.60    4.68    4.70    4.54   \n",
       "3500  600087   退市长油          0.000    0.00    0.00    0.00    0.00   \n",
       "3501  600074  ST保千里         -2.183    2.24    2.27    2.28    2.21   \n",
       "3502  600071   凤凰光学          1.930   17.43   17.22   17.79   17.02   \n",
       "3503  600069   银鸽投资          0.000    7.42    0.00    0.00    0.00   \n",
       "\n",
       "      settlement       volume  turnoverratio        amount      per       pb  \\\n",
       "0           7.38    1784994.0        0.77474  1.299070e+07   25.034    2.507   \n",
       "1           9.43          0.0        0.00000  0.000000e+00   58.938    4.066   \n",
       "2          11.61    3129670.0        0.49677  3.575766e+07   19.373    4.366   \n",
       "3          17.24    3196827.0        3.09545  5.531282e+07   44.308    3.652   \n",
       "4           9.13  360724680.0        2.78472  3.393773e+09  157.667    5.481   \n",
       "5          23.86     925192.0        2.25223  2.121697e+07   34.224    3.850   \n",
       "6          35.85     224455.0        0.37240  7.902142e+06   46.387    6.863   \n",
       "7          37.68     535000.0        0.63407  1.991867e+07   42.375    6.336   \n",
       "8          33.17    2614902.0        2.17909  8.252070e+07  104.467    3.809   \n",
       "9          11.56    1612548.0        0.84839  1.840273e+07   18.306    2.989   \n",
       "10        192.70    5645599.0        3.83154  1.112856e+09   94.308   25.238   \n",
       "11         32.59     601000.0        3.00500  1.905178e+07   19.935    2.580   \n",
       "12         19.86    3043696.0        3.04370  5.994944e+07   20.460    2.523   \n",
       "13          9.85    2132336.0        0.87693  2.069221e+07   23.048    1.490   \n",
       "14         78.24    1058405.0        5.29203  8.038080e+07   34.176    4.660   \n",
       "15         13.82    2758112.0        2.19455  3.743481e+07   43.839    3.171   \n",
       "16         23.59    1438137.0        5.32643  3.261158e+07   25.851    2.591   \n",
       "17         24.74    4852872.0       14.55859  1.141641e+08   28.463    6.161   \n",
       "18         13.38    5486201.0        1.37155  7.221390e+07   36.667    3.301   \n",
       "19         19.35     525710.0        0.38485  1.007653e+07   26.819    3.071   \n",
       "20         13.99    1577950.0        2.20600  2.123359e+07   28.489    2.676   \n",
       "21         29.95    3249959.0       12.99984  9.247120e+07   34.084    6.177   \n",
       "22         29.70    1479845.0        3.71329  4.277741e+07   46.617    6.996   \n",
       "23         36.04    1119961.0        1.05946  4.035996e+07   67.698    8.849   \n",
       "24         11.62    2528389.0        3.83095  2.832248e+07   26.241    2.126   \n",
       "25         35.88          0.0        0.00000  0.000000e+00   33.608    3.009   \n",
       "26         50.64    1297653.0        0.35778  6.750314e+07   77.979    6.100   \n",
       "27         34.01    3584083.0        9.54315  1.186333e+08   46.153    5.364   \n",
       "28         21.49    8342710.0       15.97608  1.690305e+08   35.786    4.078   \n",
       "29         21.39    1940645.0        3.45926  4.049307e+07   64.514    3.512   \n",
       "...          ...          ...            ...           ...      ...      ...   \n",
       "3474       16.80          0.0        0.00000  0.000000e+00 -336.000    8.143   \n",
       "3475       13.80     825618.0        0.78630  1.148406e+07  132.762    5.537   \n",
       "3476        6.74          0.0        0.00000  0.000000e+00   -4.956    7.663   \n",
       "3477        3.66    7020806.0        0.50920  2.558911e+07   -8.667    1.255   \n",
       "3478        4.83          0.0        0.00000  0.000000e+00   32.200   49.948   \n",
       "3479        8.10     456142.0        0.23320  3.664883e+06  399.500  238.507   \n",
       "3480        2.56    7433530.0        0.73833  1.885118e+07   -4.379    2.626   \n",
       "3481        4.54    1375514.0        0.05753  6.199642e+06   -5.488    1.536   \n",
       "3482        0.87          0.0        0.00000  0.000000e+00   -3.486    1.432   \n",
       "3483        4.49    8734691.0        1.31230  3.835258e+07  -44.877    3.505   \n",
       "3484        6.63    1079694.0        0.45915  7.087585e+06  -47.429    6.371   \n",
       "3485        3.97   16136488.0        2.85136  6.225101e+07   17.220    0.775   \n",
       "3486        4.98    2714101.0        0.53339  1.327585e+07  -59.703   21.410   \n",
       "3487       18.28     209085.0        0.16108  3.724200e+06   68.615   59.073   \n",
       "3488        8.05    2183801.0        0.64909  1.836348e+07  -13.255   -9.674   \n",
       "3489       15.58    2106800.0        0.73834  3.249153e+07  154.200    3.609   \n",
       "3490       13.10     272300.0        0.13451  3.574928e+06  184.571   30.322   \n",
       "3491       12.25    3409225.0        1.41274  4.103130e+07  -78.867  492.917   \n",
       "3492        4.44    2633430.0        0.28245  1.169936e+07   -9.122    2.290   \n",
       "3493        6.51    7853630.0        1.09048  4.996523e+07   57.489    5.621   \n",
       "3494        4.13    3765147.0        0.49961  1.537594e+07   38.679    2.461   \n",
       "3495        8.62    4541551.0        1.19464  3.837143e+07 -128.988   17.916   \n",
       "3496        1.87          0.0        0.00000  0.000000e+00 -935.000    4.503   \n",
       "3497        5.60    3940538.0        0.38810  2.188287e+07   -8.931    1.653   \n",
       "3498        4.82   18789104.0        3.68989  8.731834e+07  -23.726    1.984   \n",
       "3499        4.71    2350250.0        0.69839  1.082024e+07  153.333    2.229   \n",
       "3500        0.00          0.0        0.00000  0.000000e+00    0.000    0.000   \n",
       "3501        2.29   45891285.0        4.47260  1.029404e+08    6.400    1.137   \n",
       "3502       17.10    2073395.0        0.87311  3.612250e+07  124.500    9.771   \n",
       "3503        7.42          0.0        0.00000  0.000000e+00  -23.188    4.549   \n",
       "\n",
       "            mktcap           nmc  \n",
       "0     4.181760e+05  1.672704e+05  \n",
       "1     4.063731e+05  4.009605e+05  \n",
       "2     7.289130e+05  7.200900e+05  \n",
       "3     5.186592e+05  1.784592e+05  \n",
       "4     2.043288e+07  1.225423e+07  \n",
       "5     1.709088e+05  9.419396e+04  \n",
       "6     2.815297e+05  2.096863e+05  \n",
       "7     1.118700e+06  3.146344e+05  \n",
       "8     3.760800e+05  3.760800e+05  \n",
       "9     3.580187e+05  2.157311e+05  \n",
       "10    4.046704e+06  2.941897e+06  \n",
       "11    2.517600e+05  6.294000e+04  \n",
       "12    9.780000e+05  1.956000e+05  \n",
       "13    5.662800e+05  2.353792e+05  \n",
       "14    6.042400e+05  1.510600e+05  \n",
       "15    3.004477e+05  1.707991e+05  \n",
       "16    2.428920e+05  6.072300e+04  \n",
       "17    3.101335e+05  7.753349e+04  \n",
       "18    5.280000e+05  5.280000e+05  \n",
       "19    3.948509e+05  2.637746e+05  \n",
       "20    2.142400e+05  9.577878e+04  \n",
       "21    2.829000e+05  7.072500e+04  \n",
       "22    2.908880e+05  1.114678e+05  \n",
       "23    8.037120e+05  3.792903e+05  \n",
       "24    2.412696e+05  7.325889e+04  \n",
       "25    3.121560e+05  1.968438e+05  \n",
       "26    1.875131e+06  1.875131e+06  \n",
       "27    4.990036e+05  1.248006e+05  \n",
       "28    4.185955e+05  1.046489e+05  \n",
       "29    3.444063e+05  1.154538e+05  \n",
       "...            ...           ...  \n",
       "3474  3.864000e+05  3.864000e+05  \n",
       "3475  2.041122e+05  1.463700e+05  \n",
       "3476  1.080910e+06  1.080910e+06  \n",
       "3477  5.018796e+05  5.018796e+05  \n",
       "3478  1.928848e+05  1.928848e+05  \n",
       "3479  1.562844e+05  1.562844e+05  \n",
       "3480  2.557272e+05  2.557272e+05  \n",
       "3481  1.075866e+06  1.075866e+06  \n",
       "3482  4.110694e+05  4.110694e+05  \n",
       "3483  2.915328e+05  2.915328e+05  \n",
       "3484  1.540220e+05  1.540220e+05  \n",
       "3485  2.423240e+05  2.173143e+05  \n",
       "3486  2.457684e+05  2.457684e+05  \n",
       "3487  2.315632e+05  2.315632e+05  \n",
       "3488  2.842932e+05  2.842932e+05  \n",
       "3489  7.041776e+05  4.399959e+05  \n",
       "3490  2.615601e+05  2.615601e+05  \n",
       "3491  2.854816e+05  2.854816e+05  \n",
       "3492  4.181652e+05  4.167547e+05  \n",
       "3493  8.901309e+05  4.616467e+05  \n",
       "3494  4.097807e+05  3.089858e+05  \n",
       "3495  3.197146e+05  3.197146e+05  \n",
       "3496  2.788358e+05  2.788358e+05  \n",
       "3497  5.625002e+05  5.625002e+05  \n",
       "3498  2.347434e+05  2.347434e+05  \n",
       "3499  2.012098e+05  1.548020e+05  \n",
       "3500  0.000000e+00  0.000000e+00  \n",
       "3501  5.460865e+05  2.298359e+05  \n",
       "3502  4.139145e+05  4.139145e+05  \n",
       "3503  9.268344e+05  6.124276e+05  \n",
       "\n",
       "[3504 rows x 15 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv(\"c:/stockdata/stockdailydata/20190315\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
